{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url = \"https://raw.githubusercontent.com/dwdii/IS608-VizAnalytics/master/FinalProject/Data/CO-EST2014-alldata.csv\"\n",
    "pop2014 =pd.read_csv(url,encoding='latin-1',dtype={'STATE': 'str', 'COUNTY': 'str'})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RINTERNATIONALMIG2013</th>\n",
       "      <th>RINTERNATIONALMIG2014</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>000</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736</td>\n",
       "      <td>4780127</td>\n",
       "      <td>4785822</td>\n",
       "      <td>...</td>\n",
       "      <td>1.165832</td>\n",
       "      <td>1.157861</td>\n",
       "      <td>-0.020443</td>\n",
       "      <td>-0.168414</td>\n",
       "      <td>0.396416</td>\n",
       "      <td>0.420102</td>\n",
       "      <td>1.011941</td>\n",
       "      <td>1.001333</td>\n",
       "      <td>1.562247</td>\n",
       "      <td>1.577963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>001</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Autauga County</td>\n",
       "      <td>54571</td>\n",
       "      <td>54571</td>\n",
       "      <td>54684</td>\n",
       "      <td>...</td>\n",
       "      <td>0.217533</td>\n",
       "      <td>0.199039</td>\n",
       "      <td>7.239062</td>\n",
       "      <td>-2.806268</td>\n",
       "      <td>-2.918570</td>\n",
       "      <td>2.334187</td>\n",
       "      <td>7.530079</td>\n",
       "      <td>-2.589008</td>\n",
       "      <td>-2.701037</td>\n",
       "      <td>2.533226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>003</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>182265</td>\n",
       "      <td>182265</td>\n",
       "      <td>183216</td>\n",
       "      <td>...</td>\n",
       "      <td>1.471487</td>\n",
       "      <td>1.430905</td>\n",
       "      <td>14.554892</td>\n",
       "      <td>17.834091</td>\n",
       "      <td>21.989409</td>\n",
       "      <td>19.107379</td>\n",
       "      <td>15.890352</td>\n",
       "      <td>19.260182</td>\n",
       "      <td>23.460897</td>\n",
       "      <td>20.538283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>005</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Barbour County</td>\n",
       "      <td>27457</td>\n",
       "      <td>27457</td>\n",
       "      <td>27336</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.036936</td>\n",
       "      <td>0.037130</td>\n",
       "      <td>-4.765309</td>\n",
       "      <td>-2.389969</td>\n",
       "      <td>-7.017933</td>\n",
       "      <td>-2.227792</td>\n",
       "      <td>-4.618684</td>\n",
       "      <td>-2.426738</td>\n",
       "      <td>-7.054869</td>\n",
       "      <td>-2.190662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>007</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bibb County</td>\n",
       "      <td>22915</td>\n",
       "      <td>22919</td>\n",
       "      <td>22879</td>\n",
       "      <td>...</td>\n",
       "      <td>0.132926</td>\n",
       "      <td>0.133304</td>\n",
       "      <td>-5.611697</td>\n",
       "      <td>-4.980826</td>\n",
       "      <td>-6.734902</td>\n",
       "      <td>-0.355477</td>\n",
       "      <td>-5.567855</td>\n",
       "      <td>-4.980826</td>\n",
       "      <td>-6.601976</td>\n",
       "      <td>-0.222173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>009</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Blount County</td>\n",
       "      <td>57322</td>\n",
       "      <td>57322</td>\n",
       "      <td>57344</td>\n",
       "      <td>...</td>\n",
       "      <td>0.190529</td>\n",
       "      <td>0.207902</td>\n",
       "      <td>1.773327</td>\n",
       "      <td>-1.143431</td>\n",
       "      <td>-1.714761</td>\n",
       "      <td>-1.975069</td>\n",
       "      <td>2.034110</td>\n",
       "      <td>-1.022158</td>\n",
       "      <td>-1.524232</td>\n",
       "      <td>-1.767167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>011</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bullock County</td>\n",
       "      <td>10914</td>\n",
       "      <td>10915</td>\n",
       "      <td>10886</td>\n",
       "      <td>...</td>\n",
       "      <td>1.226762</td>\n",
       "      <td>1.310309</td>\n",
       "      <td>-30.963783</td>\n",
       "      <td>-4.714313</td>\n",
       "      <td>-1.698594</td>\n",
       "      <td>11.979971</td>\n",
       "      <td>-29.476033</td>\n",
       "      <td>-3.488591</td>\n",
       "      <td>-0.471832</td>\n",
       "      <td>13.290280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>013</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Butler County</td>\n",
       "      <td>20947</td>\n",
       "      <td>20946</td>\n",
       "      <td>20945</td>\n",
       "      <td>...</td>\n",
       "      <td>0.294855</td>\n",
       "      <td>0.295676</td>\n",
       "      <td>-14.079431</td>\n",
       "      <td>-11.683096</td>\n",
       "      <td>-5.307386</td>\n",
       "      <td>-0.049279</td>\n",
       "      <td>-13.791115</td>\n",
       "      <td>-11.391019</td>\n",
       "      <td>-5.012531</td>\n",
       "      <td>0.246396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>015</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun County</td>\n",
       "      <td>118572</td>\n",
       "      <td>118586</td>\n",
       "      <td>118443</td>\n",
       "      <td>...</td>\n",
       "      <td>0.282279</td>\n",
       "      <td>0.266709</td>\n",
       "      <td>-6.147255</td>\n",
       "      <td>-4.544217</td>\n",
       "      <td>-5.500169</td>\n",
       "      <td>-4.052258</td>\n",
       "      <td>-5.918638</td>\n",
       "      <td>-4.178297</td>\n",
       "      <td>-5.217890</td>\n",
       "      <td>-3.785549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>017</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chambers County</td>\n",
       "      <td>34215</td>\n",
       "      <td>34170</td>\n",
       "      <td>34111</td>\n",
       "      <td>...</td>\n",
       "      <td>0.937564</td>\n",
       "      <td>0.937715</td>\n",
       "      <td>-2.730676</td>\n",
       "      <td>3.877164</td>\n",
       "      <td>3.281474</td>\n",
       "      <td>-2.578717</td>\n",
       "      <td>-1.820451</td>\n",
       "      <td>4.728966</td>\n",
       "      <td>4.219038</td>\n",
       "      <td>-1.641002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>019</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cherokee County</td>\n",
       "      <td>25989</td>\n",
       "      <td>25986</td>\n",
       "      <td>25968</td>\n",
       "      <td>...</td>\n",
       "      <td>0.191821</td>\n",
       "      <td>0.191747</td>\n",
       "      <td>6.302723</td>\n",
       "      <td>1.228643</td>\n",
       "      <td>5.754623</td>\n",
       "      <td>0.191747</td>\n",
       "      <td>6.494879</td>\n",
       "      <td>1.420618</td>\n",
       "      <td>5.946444</td>\n",
       "      <td>0.383494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>021</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chilton County</td>\n",
       "      <td>43643</td>\n",
       "      <td>43631</td>\n",
       "      <td>43682</td>\n",
       "      <td>...</td>\n",
       "      <td>0.365526</td>\n",
       "      <td>0.432965</td>\n",
       "      <td>-1.372511</td>\n",
       "      <td>-2.744174</td>\n",
       "      <td>0.342681</td>\n",
       "      <td>0.136726</td>\n",
       "      <td>-0.960758</td>\n",
       "      <td>-2.446889</td>\n",
       "      <td>0.708207</td>\n",
       "      <td>0.569690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>023</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Choctaw County</td>\n",
       "      <td>13859</td>\n",
       "      <td>13858</td>\n",
       "      <td>13849</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222585</td>\n",
       "      <td>0.224551</td>\n",
       "      <td>-15.517430</td>\n",
       "      <td>-0.736296</td>\n",
       "      <td>-8.309838</td>\n",
       "      <td>-1.347305</td>\n",
       "      <td>-15.298874</td>\n",
       "      <td>-0.515407</td>\n",
       "      <td>-8.087253</td>\n",
       "      <td>-1.122754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>025</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clarke County</td>\n",
       "      <td>25833</td>\n",
       "      <td>25840</td>\n",
       "      <td>25782</td>\n",
       "      <td>...</td>\n",
       "      <td>0.397346</td>\n",
       "      <td>0.399114</td>\n",
       "      <td>-6.228832</td>\n",
       "      <td>-17.612293</td>\n",
       "      <td>-0.198673</td>\n",
       "      <td>-8.461216</td>\n",
       "      <td>-5.878460</td>\n",
       "      <td>-17.257683</td>\n",
       "      <td>0.198673</td>\n",
       "      <td>-8.062102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay County</td>\n",
       "      <td>13932</td>\n",
       "      <td>13932</td>\n",
       "      <td>13886</td>\n",
       "      <td>...</td>\n",
       "      <td>0.148307</td>\n",
       "      <td>0.147831</td>\n",
       "      <td>-10.739034</td>\n",
       "      <td>-13.263577</td>\n",
       "      <td>4.523377</td>\n",
       "      <td>5.913223</td>\n",
       "      <td>-10.666473</td>\n",
       "      <td>-13.189890</td>\n",
       "      <td>4.671684</td>\n",
       "      <td>6.061054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>029</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cleburne County</td>\n",
       "      <td>14972</td>\n",
       "      <td>14972</td>\n",
       "      <td>14969</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-3.674506</td>\n",
       "      <td>-5.086164</td>\n",
       "      <td>6.146651</td>\n",
       "      <td>3.588398</td>\n",
       "      <td>-3.674506</td>\n",
       "      <td>-5.086164</td>\n",
       "      <td>6.146651</td>\n",
       "      <td>3.588398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>031</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coffee County</td>\n",
       "      <td>49948</td>\n",
       "      <td>49948</td>\n",
       "      <td>50179</td>\n",
       "      <td>...</td>\n",
       "      <td>3.154451</td>\n",
       "      <td>2.928171</td>\n",
       "      <td>0.377568</td>\n",
       "      <td>7.690643</td>\n",
       "      <td>-13.185995</td>\n",
       "      <td>-3.419475</td>\n",
       "      <td>2.484003</td>\n",
       "      <td>11.998190</td>\n",
       "      <td>-10.031545</td>\n",
       "      <td>-0.491304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>033</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Colbert County</td>\n",
       "      <td>54428</td>\n",
       "      <td>54428</td>\n",
       "      <td>54505</td>\n",
       "      <td>...</td>\n",
       "      <td>0.605660</td>\n",
       "      <td>0.623613</td>\n",
       "      <td>-0.128513</td>\n",
       "      <td>1.101868</td>\n",
       "      <td>1.798627</td>\n",
       "      <td>1.760789</td>\n",
       "      <td>0.477336</td>\n",
       "      <td>1.689530</td>\n",
       "      <td>2.404287</td>\n",
       "      <td>2.384402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>035</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Conecuh County</td>\n",
       "      <td>13228</td>\n",
       "      <td>13228</td>\n",
       "      <td>13219</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-4.933212</td>\n",
       "      <td>-7.575178</td>\n",
       "      <td>-6.176891</td>\n",
       "      <td>-14.940551</td>\n",
       "      <td>-4.933212</td>\n",
       "      <td>-7.575178</td>\n",
       "      <td>-6.176891</td>\n",
       "      <td>-14.940551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>037</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coosa County</td>\n",
       "      <td>11539</td>\n",
       "      <td>11758</td>\n",
       "      <td>11757</td>\n",
       "      <td>...</td>\n",
       "      <td>0.089904</td>\n",
       "      <td>0.091112</td>\n",
       "      <td>-34.370806</td>\n",
       "      <td>-11.276360</td>\n",
       "      <td>-4.585094</td>\n",
       "      <td>-16.126828</td>\n",
       "      <td>-34.370806</td>\n",
       "      <td>-11.276360</td>\n",
       "      <td>-4.495190</td>\n",
       "      <td>-16.035716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>039</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Covington County</td>\n",
       "      <td>37765</td>\n",
       "      <td>37765</td>\n",
       "      <td>37784</td>\n",
       "      <td>...</td>\n",
       "      <td>0.211475</td>\n",
       "      <td>0.211182</td>\n",
       "      <td>6.672557</td>\n",
       "      <td>-4.640249</td>\n",
       "      <td>0.555122</td>\n",
       "      <td>3.986062</td>\n",
       "      <td>6.857173</td>\n",
       "      <td>-4.455694</td>\n",
       "      <td>0.766597</td>\n",
       "      <td>4.197244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>041</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Crenshaw County</td>\n",
       "      <td>13906</td>\n",
       "      <td>13906</td>\n",
       "      <td>13866</td>\n",
       "      <td>...</td>\n",
       "      <td>1.432049</td>\n",
       "      <td>1.503383</td>\n",
       "      <td>1.727862</td>\n",
       "      <td>4.088073</td>\n",
       "      <td>-1.432049</td>\n",
       "      <td>3.078355</td>\n",
       "      <td>3.023758</td>\n",
       "      <td>5.379043</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.581737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>043</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cullman County</td>\n",
       "      <td>80406</td>\n",
       "      <td>80410</td>\n",
       "      <td>80454</td>\n",
       "      <td>...</td>\n",
       "      <td>0.508862</td>\n",
       "      <td>0.530628</td>\n",
       "      <td>-1.416950</td>\n",
       "      <td>-1.019799</td>\n",
       "      <td>4.145361</td>\n",
       "      <td>5.256923</td>\n",
       "      <td>-0.981921</td>\n",
       "      <td>-0.621829</td>\n",
       "      <td>4.654222</td>\n",
       "      <td>5.787551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>045</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dale County</td>\n",
       "      <td>50251</td>\n",
       "      <td>50251</td>\n",
       "      <td>50340</td>\n",
       "      <td>...</td>\n",
       "      <td>2.675852</td>\n",
       "      <td>2.335672</td>\n",
       "      <td>-10.814040</td>\n",
       "      <td>-5.179541</td>\n",
       "      <td>-15.316260</td>\n",
       "      <td>-11.919983</td>\n",
       "      <td>-9.698780</td>\n",
       "      <td>-0.577718</td>\n",
       "      <td>-12.640407</td>\n",
       "      <td>-9.584311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>047</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dallas County</td>\n",
       "      <td>43820</td>\n",
       "      <td>43820</td>\n",
       "      <td>43836</td>\n",
       "      <td>...</td>\n",
       "      <td>0.376732</td>\n",
       "      <td>0.381802</td>\n",
       "      <td>-15.667176</td>\n",
       "      <td>-11.293921</td>\n",
       "      <td>-16.976490</td>\n",
       "      <td>-9.640509</td>\n",
       "      <td>-15.414480</td>\n",
       "      <td>-11.015059</td>\n",
       "      <td>-16.599757</td>\n",
       "      <td>-9.258707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>049</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>DeKalb County</td>\n",
       "      <td>71109</td>\n",
       "      <td>71115</td>\n",
       "      <td>71118</td>\n",
       "      <td>...</td>\n",
       "      <td>1.029445</td>\n",
       "      <td>1.084820</td>\n",
       "      <td>0.280743</td>\n",
       "      <td>-9.304875</td>\n",
       "      <td>-1.903768</td>\n",
       "      <td>0.366303</td>\n",
       "      <td>1.333530</td>\n",
       "      <td>-8.461533</td>\n",
       "      <td>-0.874323</td>\n",
       "      <td>1.451123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>051</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Elmore County</td>\n",
       "      <td>79303</td>\n",
       "      <td>79296</td>\n",
       "      <td>79444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.508685</td>\n",
       "      <td>0.469759</td>\n",
       "      <td>3.236591</td>\n",
       "      <td>0.723305</td>\n",
       "      <td>1.277916</td>\n",
       "      <td>-1.322743</td>\n",
       "      <td>3.562759</td>\n",
       "      <td>1.421668</td>\n",
       "      <td>1.786600</td>\n",
       "      <td>-0.852984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>053</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Escambia County</td>\n",
       "      <td>38319</td>\n",
       "      <td>38319</td>\n",
       "      <td>38312</td>\n",
       "      <td>...</td>\n",
       "      <td>0.158017</td>\n",
       "      <td>0.185122</td>\n",
       "      <td>-3.475579</td>\n",
       "      <td>-3.776059</td>\n",
       "      <td>-4.398151</td>\n",
       "      <td>-3.411525</td>\n",
       "      <td>-3.214258</td>\n",
       "      <td>-3.618723</td>\n",
       "      <td>-4.240134</td>\n",
       "      <td>-3.226404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>055</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Etowah County</td>\n",
       "      <td>104430</td>\n",
       "      <td>104427</td>\n",
       "      <td>104501</td>\n",
       "      <td>...</td>\n",
       "      <td>0.604937</td>\n",
       "      <td>0.607249</td>\n",
       "      <td>-1.005694</td>\n",
       "      <td>2.089784</td>\n",
       "      <td>-1.910834</td>\n",
       "      <td>-1.831387</td>\n",
       "      <td>-0.469324</td>\n",
       "      <td>2.617023</td>\n",
       "      <td>-1.305897</td>\n",
       "      <td>-1.224138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>057</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Fayette County</td>\n",
       "      <td>17241</td>\n",
       "      <td>17241</td>\n",
       "      <td>17247</td>\n",
       "      <td>...</td>\n",
       "      <td>0.118025</td>\n",
       "      <td>0.118403</td>\n",
       "      <td>-5.010341</td>\n",
       "      <td>-0.704556</td>\n",
       "      <td>-4.425954</td>\n",
       "      <td>0.355208</td>\n",
       "      <td>-4.952081</td>\n",
       "      <td>-0.645843</td>\n",
       "      <td>-4.307928</td>\n",
       "      <td>0.473611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3163</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>131</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washington County</td>\n",
       "      <td>131887</td>\n",
       "      <td>131885</td>\n",
       "      <td>131897</td>\n",
       "      <td>...</td>\n",
       "      <td>0.407045</td>\n",
       "      <td>0.421057</td>\n",
       "      <td>-0.795292</td>\n",
       "      <td>0.785682</td>\n",
       "      <td>-2.291512</td>\n",
       "      <td>1.646635</td>\n",
       "      <td>-0.409007</td>\n",
       "      <td>1.140750</td>\n",
       "      <td>-1.884467</td>\n",
       "      <td>2.067692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3164</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>133</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waukesha County</td>\n",
       "      <td>389891</td>\n",
       "      <td>389938</td>\n",
       "      <td>390079</td>\n",
       "      <td>...</td>\n",
       "      <td>0.917918</td>\n",
       "      <td>0.920084</td>\n",
       "      <td>-0.768369</td>\n",
       "      <td>2.146999</td>\n",
       "      <td>0.124593</td>\n",
       "      <td>0.757866</td>\n",
       "      <td>0.064031</td>\n",
       "      <td>2.981802</td>\n",
       "      <td>1.042510</td>\n",
       "      <td>1.677950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3165</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>135</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waupaca County</td>\n",
       "      <td>52410</td>\n",
       "      <td>52410</td>\n",
       "      <td>52417</td>\n",
       "      <td>...</td>\n",
       "      <td>0.249424</td>\n",
       "      <td>0.249334</td>\n",
       "      <td>3.073868</td>\n",
       "      <td>-2.261294</td>\n",
       "      <td>6.408289</td>\n",
       "      <td>-0.306872</td>\n",
       "      <td>3.302976</td>\n",
       "      <td>-2.031332</td>\n",
       "      <td>6.657713</td>\n",
       "      <td>-0.057539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3166</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>137</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waushara County</td>\n",
       "      <td>24496</td>\n",
       "      <td>24496</td>\n",
       "      <td>24492</td>\n",
       "      <td>...</td>\n",
       "      <td>0.491733</td>\n",
       "      <td>0.494764</td>\n",
       "      <td>4.932534</td>\n",
       "      <td>-2.365078</td>\n",
       "      <td>-4.466572</td>\n",
       "      <td>-5.978395</td>\n",
       "      <td>5.340182</td>\n",
       "      <td>-1.957306</td>\n",
       "      <td>-3.974840</td>\n",
       "      <td>-5.483632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3167</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>139</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Winnebago County</td>\n",
       "      <td>166994</td>\n",
       "      <td>166994</td>\n",
       "      <td>167004</td>\n",
       "      <td>...</td>\n",
       "      <td>0.491133</td>\n",
       "      <td>0.495764</td>\n",
       "      <td>0.298898</td>\n",
       "      <td>2.998287</td>\n",
       "      <td>0.786996</td>\n",
       "      <td>-2.384388</td>\n",
       "      <td>0.741268</td>\n",
       "      <td>3.426613</td>\n",
       "      <td>1.278129</td>\n",
       "      <td>-1.888624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3168</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>141</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Wood County</td>\n",
       "      <td>74749</td>\n",
       "      <td>74749</td>\n",
       "      <td>74780</td>\n",
       "      <td>...</td>\n",
       "      <td>0.418077</td>\n",
       "      <td>0.433745</td>\n",
       "      <td>-4.056252</td>\n",
       "      <td>-4.967343</td>\n",
       "      <td>-7.080338</td>\n",
       "      <td>-5.774236</td>\n",
       "      <td>-3.708191</td>\n",
       "      <td>-4.591436</td>\n",
       "      <td>-6.662261</td>\n",
       "      <td>-5.340490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3169</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>000</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626</td>\n",
       "      <td>563767</td>\n",
       "      <td>564358</td>\n",
       "      <td>...</td>\n",
       "      <td>0.858535</td>\n",
       "      <td>0.830923</td>\n",
       "      <td>-0.362194</td>\n",
       "      <td>9.651174</td>\n",
       "      <td>4.547821</td>\n",
       "      <td>-4.577788</td>\n",
       "      <td>0.323325</td>\n",
       "      <td>10.610525</td>\n",
       "      <td>5.406356</td>\n",
       "      <td>-3.746865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3170</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>001</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Albany County</td>\n",
       "      <td>36299</td>\n",
       "      <td>36299</td>\n",
       "      <td>36440</td>\n",
       "      <td>...</td>\n",
       "      <td>3.229379</td>\n",
       "      <td>3.210188</td>\n",
       "      <td>3.735362</td>\n",
       "      <td>2.611880</td>\n",
       "      <td>-3.362825</td>\n",
       "      <td>-3.475492</td>\n",
       "      <td>6.570965</td>\n",
       "      <td>5.412246</td>\n",
       "      <td>-0.133445</td>\n",
       "      <td>-0.265305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3171</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>003</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Big Horn County</td>\n",
       "      <td>11668</td>\n",
       "      <td>11668</td>\n",
       "      <td>11674</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.168180</td>\n",
       "      <td>-0.083556</td>\n",
       "      <td>4.867842</td>\n",
       "      <td>2.720741</td>\n",
       "      <td>17.827111</td>\n",
       "      <td>-8.522727</td>\n",
       "      <td>4.782442</td>\n",
       "      <td>2.550695</td>\n",
       "      <td>17.658930</td>\n",
       "      <td>-8.606283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3172</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>005</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Campbell County</td>\n",
       "      <td>46133</td>\n",
       "      <td>46133</td>\n",
       "      <td>46223</td>\n",
       "      <td>...</td>\n",
       "      <td>0.582684</td>\n",
       "      <td>0.580131</td>\n",
       "      <td>-2.844429</td>\n",
       "      <td>15.621197</td>\n",
       "      <td>-5.701978</td>\n",
       "      <td>-7.811043</td>\n",
       "      <td>-2.413455</td>\n",
       "      <td>16.086869</td>\n",
       "      <td>-5.119294</td>\n",
       "      <td>-7.230913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3173</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>007</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Carbon County</td>\n",
       "      <td>15885</td>\n",
       "      <td>15885</td>\n",
       "      <td>15835</td>\n",
       "      <td>...</td>\n",
       "      <td>0.254210</td>\n",
       "      <td>0.316006</td>\n",
       "      <td>-7.455849</td>\n",
       "      <td>-12.890117</td>\n",
       "      <td>3.431840</td>\n",
       "      <td>-2.591247</td>\n",
       "      <td>-7.266294</td>\n",
       "      <td>-12.699622</td>\n",
       "      <td>3.686050</td>\n",
       "      <td>-2.275241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3174</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>009</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Converse County</td>\n",
       "      <td>13833</td>\n",
       "      <td>13833</td>\n",
       "      <td>13817</td>\n",
       "      <td>...</td>\n",
       "      <td>0.282476</td>\n",
       "      <td>0.281561</td>\n",
       "      <td>-12.928060</td>\n",
       "      <td>15.581605</td>\n",
       "      <td>19.067123</td>\n",
       "      <td>-20.976314</td>\n",
       "      <td>-12.782801</td>\n",
       "      <td>15.725879</td>\n",
       "      <td>19.349599</td>\n",
       "      <td>-20.694752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3175</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>011</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Crook County</td>\n",
       "      <td>7083</td>\n",
       "      <td>7083</td>\n",
       "      <td>7108</td>\n",
       "      <td>...</td>\n",
       "      <td>0.419668</td>\n",
       "      <td>0.416493</td>\n",
       "      <td>-1.546138</td>\n",
       "      <td>-4.207574</td>\n",
       "      <td>1.119116</td>\n",
       "      <td>8.329863</td>\n",
       "      <td>-1.124464</td>\n",
       "      <td>-3.786816</td>\n",
       "      <td>1.538784</td>\n",
       "      <td>8.746356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3176</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>013</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Fremont County</td>\n",
       "      <td>40123</td>\n",
       "      <td>40123</td>\n",
       "      <td>40224</td>\n",
       "      <td>...</td>\n",
       "      <td>0.170364</td>\n",
       "      <td>0.171243</td>\n",
       "      <td>2.771831</td>\n",
       "      <td>7.832195</td>\n",
       "      <td>-4.672840</td>\n",
       "      <td>-11.546694</td>\n",
       "      <td>2.969819</td>\n",
       "      <td>7.954573</td>\n",
       "      <td>-4.502476</td>\n",
       "      <td>-11.375451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3177</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>015</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Goshen County</td>\n",
       "      <td>13249</td>\n",
       "      <td>13247</td>\n",
       "      <td>13411</td>\n",
       "      <td>...</td>\n",
       "      <td>0.733999</td>\n",
       "      <td>0.738225</td>\n",
       "      <td>14.510457</td>\n",
       "      <td>4.106475</td>\n",
       "      <td>-8.000587</td>\n",
       "      <td>-6.201093</td>\n",
       "      <td>15.102721</td>\n",
       "      <td>4.693114</td>\n",
       "      <td>-7.266588</td>\n",
       "      <td>-5.462867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3178</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>017</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Hot Springs County</td>\n",
       "      <td>4812</td>\n",
       "      <td>4812</td>\n",
       "      <td>4804</td>\n",
       "      <td>...</td>\n",
       "      <td>2.061643</td>\n",
       "      <td>2.067825</td>\n",
       "      <td>3.328826</td>\n",
       "      <td>6.007872</td>\n",
       "      <td>2.473972</td>\n",
       "      <td>-5.376344</td>\n",
       "      <td>5.201290</td>\n",
       "      <td>7.872385</td>\n",
       "      <td>4.535615</td>\n",
       "      <td>-3.308519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3179</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>019</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Johnson County</td>\n",
       "      <td>8569</td>\n",
       "      <td>8569</td>\n",
       "      <td>8568</td>\n",
       "      <td>...</td>\n",
       "      <td>0.580450</td>\n",
       "      <td>0.581564</td>\n",
       "      <td>5.001454</td>\n",
       "      <td>-3.945918</td>\n",
       "      <td>-0.928721</td>\n",
       "      <td>-8.956092</td>\n",
       "      <td>5.466705</td>\n",
       "      <td>-3.481692</td>\n",
       "      <td>-0.348270</td>\n",
       "      <td>-8.374527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3180</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>021</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Laramie County</td>\n",
       "      <td>91738</td>\n",
       "      <td>91881</td>\n",
       "      <td>92199</td>\n",
       "      <td>...</td>\n",
       "      <td>1.351748</td>\n",
       "      <td>1.060269</td>\n",
       "      <td>-1.190438</td>\n",
       "      <td>15.566320</td>\n",
       "      <td>4.694442</td>\n",
       "      <td>-1.787905</td>\n",
       "      <td>-0.779195</td>\n",
       "      <td>18.041567</td>\n",
       "      <td>6.046190</td>\n",
       "      <td>-0.727636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3181</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>023</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Lincoln County</td>\n",
       "      <td>18106</td>\n",
       "      <td>18106</td>\n",
       "      <td>18075</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.054211</td>\n",
       "      <td>-9.811802</td>\n",
       "      <td>-11.578068</td>\n",
       "      <td>14.288867</td>\n",
       "      <td>5.529504</td>\n",
       "      <td>-9.811802</td>\n",
       "      <td>-11.578068</td>\n",
       "      <td>14.288867</td>\n",
       "      <td>5.583715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3182</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>025</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Natrona County</td>\n",
       "      <td>75450</td>\n",
       "      <td>75450</td>\n",
       "      <td>75466</td>\n",
       "      <td>...</td>\n",
       "      <td>0.538075</td>\n",
       "      <td>0.528363</td>\n",
       "      <td>7.189792</td>\n",
       "      <td>23.120269</td>\n",
       "      <td>24.288458</td>\n",
       "      <td>0.233463</td>\n",
       "      <td>7.690181</td>\n",
       "      <td>23.636059</td>\n",
       "      <td>24.826533</td>\n",
       "      <td>0.761825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3183</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>027</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Niobrara County</td>\n",
       "      <td>2484</td>\n",
       "      <td>2484</td>\n",
       "      <td>2491</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.402010</td>\n",
       "      <td>1.209921</td>\n",
       "      <td>27.866242</td>\n",
       "      <td>-39.106145</td>\n",
       "      <td>-0.402010</td>\n",
       "      <td>1.209921</td>\n",
       "      <td>27.866242</td>\n",
       "      <td>-39.106145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3184</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>029</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Park County</td>\n",
       "      <td>28205</td>\n",
       "      <td>28205</td>\n",
       "      <td>28262</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311272</td>\n",
       "      <td>1.375918</td>\n",
       "      <td>4.618449</td>\n",
       "      <td>8.101690</td>\n",
       "      <td>7.626081</td>\n",
       "      <td>-9.390640</td>\n",
       "      <td>6.204939</td>\n",
       "      <td>9.323928</td>\n",
       "      <td>8.937352</td>\n",
       "      <td>-8.014722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3185</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>031</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Platte County</td>\n",
       "      <td>8667</td>\n",
       "      <td>8667</td>\n",
       "      <td>8680</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.228964</td>\n",
       "      <td>-0.228128</td>\n",
       "      <td>4.487917</td>\n",
       "      <td>5.506166</td>\n",
       "      <td>2.404121</td>\n",
       "      <td>6.615718</td>\n",
       "      <td>4.257768</td>\n",
       "      <td>5.276742</td>\n",
       "      <td>2.175157</td>\n",
       "      <td>6.387590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3186</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>033</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sheridan County</td>\n",
       "      <td>29116</td>\n",
       "      <td>29116</td>\n",
       "      <td>29148</td>\n",
       "      <td>...</td>\n",
       "      <td>1.110475</td>\n",
       "      <td>1.102425</td>\n",
       "      <td>0.958527</td>\n",
       "      <td>8.458886</td>\n",
       "      <td>4.509203</td>\n",
       "      <td>3.574531</td>\n",
       "      <td>2.122452</td>\n",
       "      <td>9.512000</td>\n",
       "      <td>5.619679</td>\n",
       "      <td>4.676956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3187</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>035</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sublette County</td>\n",
       "      <td>10247</td>\n",
       "      <td>10247</td>\n",
       "      <td>10231</td>\n",
       "      <td>...</td>\n",
       "      <td>2.536709</td>\n",
       "      <td>2.680699</td>\n",
       "      <td>-23.970921</td>\n",
       "      <td>15.385364</td>\n",
       "      <td>-40.684911</td>\n",
       "      <td>-16.580620</td>\n",
       "      <td>-21.514884</td>\n",
       "      <td>17.819758</td>\n",
       "      <td>-38.148202</td>\n",
       "      <td>-13.899921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3188</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>037</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sweetwater County</td>\n",
       "      <td>43806</td>\n",
       "      <td>43806</td>\n",
       "      <td>43599</td>\n",
       "      <td>...</td>\n",
       "      <td>0.199291</td>\n",
       "      <td>0.288200</td>\n",
       "      <td>1.072484</td>\n",
       "      <td>16.195058</td>\n",
       "      <td>-5.292294</td>\n",
       "      <td>-12.991188</td>\n",
       "      <td>1.300672</td>\n",
       "      <td>16.307213</td>\n",
       "      <td>-5.093003</td>\n",
       "      <td>-12.702987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3189</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>039</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Teton County</td>\n",
       "      <td>21294</td>\n",
       "      <td>21294</td>\n",
       "      <td>21290</td>\n",
       "      <td>...</td>\n",
       "      <td>1.951042</td>\n",
       "      <td>2.030681</td>\n",
       "      <td>-1.589825</td>\n",
       "      <td>1.065160</td>\n",
       "      <td>19.283559</td>\n",
       "      <td>14.038186</td>\n",
       "      <td>0.935191</td>\n",
       "      <td>2.778678</td>\n",
       "      <td>21.234602</td>\n",
       "      <td>16.068867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3190</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>041</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Uinta County</td>\n",
       "      <td>21118</td>\n",
       "      <td>21118</td>\n",
       "      <td>21103</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.380771</td>\n",
       "      <td>-0.381543</td>\n",
       "      <td>-17.563065</td>\n",
       "      <td>-5.345297</td>\n",
       "      <td>-7.139457</td>\n",
       "      <td>-14.641707</td>\n",
       "      <td>-17.991433</td>\n",
       "      <td>-5.774829</td>\n",
       "      <td>-7.520228</td>\n",
       "      <td>-15.023250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3191</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>043</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Washakie County</td>\n",
       "      <td>8533</td>\n",
       "      <td>8533</td>\n",
       "      <td>8541</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.118406</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-11.642265</td>\n",
       "      <td>-0.946354</td>\n",
       "      <td>-1.776094</td>\n",
       "      <td>-16.813737</td>\n",
       "      <td>-11.995061</td>\n",
       "      <td>-1.064648</td>\n",
       "      <td>-1.894500</td>\n",
       "      <td>-16.813737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3192</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>045</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>7208</td>\n",
       "      <td>7208</td>\n",
       "      <td>7169</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.281591</td>\n",
       "      <td>-0.278649</td>\n",
       "      <td>-11.772125</td>\n",
       "      <td>-8.054829</td>\n",
       "      <td>13.093981</td>\n",
       "      <td>2.229188</td>\n",
       "      <td>-12.052414</td>\n",
       "      <td>-8.337455</td>\n",
       "      <td>12.812390</td>\n",
       "      <td>1.950540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3193 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SUMLEV  REGION  DIVISION STATE COUNTY     STNAME             CTYNAME  \\\n",
       "0         40       3         6    01    000    Alabama             Alabama   \n",
       "1         50       3         6    01    001    Alabama      Autauga County   \n",
       "2         50       3         6    01    003    Alabama      Baldwin County   \n",
       "3         50       3         6    01    005    Alabama      Barbour County   \n",
       "4         50       3         6    01    007    Alabama         Bibb County   \n",
       "5         50       3         6    01    009    Alabama       Blount County   \n",
       "6         50       3         6    01    011    Alabama      Bullock County   \n",
       "7         50       3         6    01    013    Alabama       Butler County   \n",
       "8         50       3         6    01    015    Alabama      Calhoun County   \n",
       "9         50       3         6    01    017    Alabama     Chambers County   \n",
       "10        50       3         6    01    019    Alabama     Cherokee County   \n",
       "11        50       3         6    01    021    Alabama      Chilton County   \n",
       "12        50       3         6    01    023    Alabama      Choctaw County   \n",
       "13        50       3         6    01    025    Alabama       Clarke County   \n",
       "14        50       3         6    01    027    Alabama         Clay County   \n",
       "15        50       3         6    01    029    Alabama     Cleburne County   \n",
       "16        50       3         6    01    031    Alabama       Coffee County   \n",
       "17        50       3         6    01    033    Alabama      Colbert County   \n",
       "18        50       3         6    01    035    Alabama      Conecuh County   \n",
       "19        50       3         6    01    037    Alabama        Coosa County   \n",
       "20        50       3         6    01    039    Alabama    Covington County   \n",
       "21        50       3         6    01    041    Alabama     Crenshaw County   \n",
       "22        50       3         6    01    043    Alabama      Cullman County   \n",
       "23        50       3         6    01    045    Alabama         Dale County   \n",
       "24        50       3         6    01    047    Alabama       Dallas County   \n",
       "25        50       3         6    01    049    Alabama       DeKalb County   \n",
       "26        50       3         6    01    051    Alabama       Elmore County   \n",
       "27        50       3         6    01    053    Alabama     Escambia County   \n",
       "28        50       3         6    01    055    Alabama       Etowah County   \n",
       "29        50       3         6    01    057    Alabama      Fayette County   \n",
       "...      ...     ...       ...   ...    ...        ...                 ...   \n",
       "3163      50       2         3    55    131  Wisconsin   Washington County   \n",
       "3164      50       2         3    55    133  Wisconsin     Waukesha County   \n",
       "3165      50       2         3    55    135  Wisconsin      Waupaca County   \n",
       "3166      50       2         3    55    137  Wisconsin     Waushara County   \n",
       "3167      50       2         3    55    139  Wisconsin    Winnebago County   \n",
       "3168      50       2         3    55    141  Wisconsin         Wood County   \n",
       "3169      40       4         8    56    000    Wyoming             Wyoming   \n",
       "3170      50       4         8    56    001    Wyoming       Albany County   \n",
       "3171      50       4         8    56    003    Wyoming     Big Horn County   \n",
       "3172      50       4         8    56    005    Wyoming     Campbell County   \n",
       "3173      50       4         8    56    007    Wyoming       Carbon County   \n",
       "3174      50       4         8    56    009    Wyoming     Converse County   \n",
       "3175      50       4         8    56    011    Wyoming        Crook County   \n",
       "3176      50       4         8    56    013    Wyoming      Fremont County   \n",
       "3177      50       4         8    56    015    Wyoming       Goshen County   \n",
       "3178      50       4         8    56    017    Wyoming  Hot Springs County   \n",
       "3179      50       4         8    56    019    Wyoming      Johnson County   \n",
       "3180      50       4         8    56    021    Wyoming      Laramie County   \n",
       "3181      50       4         8    56    023    Wyoming      Lincoln County   \n",
       "3182      50       4         8    56    025    Wyoming      Natrona County   \n",
       "3183      50       4         8    56    027    Wyoming     Niobrara County   \n",
       "3184      50       4         8    56    029    Wyoming         Park County   \n",
       "3185      50       4         8    56    031    Wyoming       Platte County   \n",
       "3186      50       4         8    56    033    Wyoming     Sheridan County   \n",
       "3187      50       4         8    56    035    Wyoming     Sublette County   \n",
       "3188      50       4         8    56    037    Wyoming   Sweetwater County   \n",
       "3189      50       4         8    56    039    Wyoming        Teton County   \n",
       "3190      50       4         8    56    041    Wyoming        Uinta County   \n",
       "3191      50       4         8    56    043    Wyoming     Washakie County   \n",
       "3192      50       4         8    56    045    Wyoming       Weston County   \n",
       "\n",
       "      CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010     ...       \\\n",
       "0           4779736            4780127          4785822     ...        \n",
       "1             54571              54571            54684     ...        \n",
       "2            182265             182265           183216     ...        \n",
       "3             27457              27457            27336     ...        \n",
       "4             22915              22919            22879     ...        \n",
       "5             57322              57322            57344     ...        \n",
       "6             10914              10915            10886     ...        \n",
       "7             20947              20946            20945     ...        \n",
       "8            118572             118586           118443     ...        \n",
       "9             34215              34170            34111     ...        \n",
       "10            25989              25986            25968     ...        \n",
       "11            43643              43631            43682     ...        \n",
       "12            13859              13858            13849     ...        \n",
       "13            25833              25840            25782     ...        \n",
       "14            13932              13932            13886     ...        \n",
       "15            14972              14972            14969     ...        \n",
       "16            49948              49948            50179     ...        \n",
       "17            54428              54428            54505     ...        \n",
       "18            13228              13228            13219     ...        \n",
       "19            11539              11758            11757     ...        \n",
       "20            37765              37765            37784     ...        \n",
       "21            13906              13906            13866     ...        \n",
       "22            80406              80410            80454     ...        \n",
       "23            50251              50251            50340     ...        \n",
       "24            43820              43820            43836     ...        \n",
       "25            71109              71115            71118     ...        \n",
       "26            79303              79296            79444     ...        \n",
       "27            38319              38319            38312     ...        \n",
       "28           104430             104427           104501     ...        \n",
       "29            17241              17241            17247     ...        \n",
       "...             ...                ...              ...     ...        \n",
       "3163         131887             131885           131897     ...        \n",
       "3164         389891             389938           390079     ...        \n",
       "3165          52410              52410            52417     ...        \n",
       "3166          24496              24496            24492     ...        \n",
       "3167         166994             166994           167004     ...        \n",
       "3168          74749              74749            74780     ...        \n",
       "3169         563626             563767           564358     ...        \n",
       "3170          36299              36299            36440     ...        \n",
       "3171          11668              11668            11674     ...        \n",
       "3172          46133              46133            46223     ...        \n",
       "3173          15885              15885            15835     ...        \n",
       "3174          13833              13833            13817     ...        \n",
       "3175           7083               7083             7108     ...        \n",
       "3176          40123              40123            40224     ...        \n",
       "3177          13249              13247            13411     ...        \n",
       "3178           4812               4812             4804     ...        \n",
       "3179           8569               8569             8568     ...        \n",
       "3180          91738              91881            92199     ...        \n",
       "3181          18106              18106            18075     ...        \n",
       "3182          75450              75450            75466     ...        \n",
       "3183           2484               2484             2491     ...        \n",
       "3184          28205              28205            28262     ...        \n",
       "3185           8667               8667             8680     ...        \n",
       "3186          29116              29116            29148     ...        \n",
       "3187          10247              10247            10231     ...        \n",
       "3188          43806              43806            43599     ...        \n",
       "3189          21294              21294            21290     ...        \n",
       "3190          21118              21118            21103     ...        \n",
       "3191           8533               8533             8541     ...        \n",
       "3192           7208               7208             7169     ...        \n",
       "\n",
       "      RINTERNATIONALMIG2013  RINTERNATIONALMIG2014  RDOMESTICMIG2011  \\\n",
       "0                  1.165832               1.157861         -0.020443   \n",
       "1                  0.217533               0.199039          7.239062   \n",
       "2                  1.471487               1.430905         14.554892   \n",
       "3                 -0.036936               0.037130         -4.765309   \n",
       "4                  0.132926               0.133304         -5.611697   \n",
       "5                  0.190529               0.207902          1.773327   \n",
       "6                  1.226762               1.310309        -30.963783   \n",
       "7                  0.294855               0.295676        -14.079431   \n",
       "8                  0.282279               0.266709         -6.147255   \n",
       "9                  0.937564               0.937715         -2.730676   \n",
       "10                 0.191821               0.191747          6.302723   \n",
       "11                 0.365526               0.432965         -1.372511   \n",
       "12                 0.222585               0.224551        -15.517430   \n",
       "13                 0.397346               0.399114         -6.228832   \n",
       "14                 0.148307               0.147831        -10.739034   \n",
       "15                 0.000000               0.000000         -3.674506   \n",
       "16                 3.154451               2.928171          0.377568   \n",
       "17                 0.605660               0.623613         -0.128513   \n",
       "18                 0.000000               0.000000         -4.933212   \n",
       "19                 0.089904               0.091112        -34.370806   \n",
       "20                 0.211475               0.211182          6.672557   \n",
       "21                 1.432049               1.503383          1.727862   \n",
       "22                 0.508862               0.530628         -1.416950   \n",
       "23                 2.675852               2.335672        -10.814040   \n",
       "24                 0.376732               0.381802        -15.667176   \n",
       "25                 1.029445               1.084820          0.280743   \n",
       "26                 0.508685               0.469759          3.236591   \n",
       "27                 0.158017               0.185122         -3.475579   \n",
       "28                 0.604937               0.607249         -1.005694   \n",
       "29                 0.118025               0.118403         -5.010341   \n",
       "...                     ...                    ...               ...   \n",
       "3163               0.407045               0.421057         -0.795292   \n",
       "3164               0.917918               0.920084         -0.768369   \n",
       "3165               0.249424               0.249334          3.073868   \n",
       "3166               0.491733               0.494764          4.932534   \n",
       "3167               0.491133               0.495764          0.298898   \n",
       "3168               0.418077               0.433745         -4.056252   \n",
       "3169               0.858535               0.830923         -0.362194   \n",
       "3170               3.229379               3.210188          3.735362   \n",
       "3171              -0.168180              -0.083556          4.867842   \n",
       "3172               0.582684               0.580131         -2.844429   \n",
       "3173               0.254210               0.316006         -7.455849   \n",
       "3174               0.282476               0.281561        -12.928060   \n",
       "3175               0.419668               0.416493         -1.546138   \n",
       "3176               0.170364               0.171243          2.771831   \n",
       "3177               0.733999               0.738225         14.510457   \n",
       "3178               2.061643               2.067825          3.328826   \n",
       "3179               0.580450               0.581564          5.001454   \n",
       "3180               1.351748               1.060269         -1.190438   \n",
       "3181               0.000000               0.054211         -9.811802   \n",
       "3182               0.538075               0.528363          7.189792   \n",
       "3183               0.000000               0.000000         -0.402010   \n",
       "3184               1.311272               1.375918          4.618449   \n",
       "3185              -0.228964              -0.228128          4.487917   \n",
       "3186               1.110475               1.102425          0.958527   \n",
       "3187               2.536709               2.680699        -23.970921   \n",
       "3188               0.199291               0.288200          1.072484   \n",
       "3189               1.951042               2.030681         -1.589825   \n",
       "3190              -0.380771              -0.381543        -17.563065   \n",
       "3191              -0.118406               0.000000        -11.642265   \n",
       "3192              -0.281591              -0.278649        -11.772125   \n",
       "\n",
       "      RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  RNETMIG2011  \\\n",
       "0            -0.168414          0.396416          0.420102     1.011941   \n",
       "1            -2.806268         -2.918570          2.334187     7.530079   \n",
       "2            17.834091         21.989409         19.107379    15.890352   \n",
       "3            -2.389969         -7.017933         -2.227792    -4.618684   \n",
       "4            -4.980826         -6.734902         -0.355477    -5.567855   \n",
       "5            -1.143431         -1.714761         -1.975069     2.034110   \n",
       "6            -4.714313         -1.698594         11.979971   -29.476033   \n",
       "7           -11.683096         -5.307386         -0.049279   -13.791115   \n",
       "8            -4.544217         -5.500169         -4.052258    -5.918638   \n",
       "9             3.877164          3.281474         -2.578717    -1.820451   \n",
       "10            1.228643          5.754623          0.191747     6.494879   \n",
       "11           -2.744174          0.342681          0.136726    -0.960758   \n",
       "12           -0.736296         -8.309838         -1.347305   -15.298874   \n",
       "13          -17.612293         -0.198673         -8.461216    -5.878460   \n",
       "14          -13.263577          4.523377          5.913223   -10.666473   \n",
       "15           -5.086164          6.146651          3.588398    -3.674506   \n",
       "16            7.690643        -13.185995         -3.419475     2.484003   \n",
       "17            1.101868          1.798627          1.760789     0.477336   \n",
       "18           -7.575178         -6.176891        -14.940551    -4.933212   \n",
       "19          -11.276360         -4.585094        -16.126828   -34.370806   \n",
       "20           -4.640249          0.555122          3.986062     6.857173   \n",
       "21            4.088073         -1.432049          3.078355     3.023758   \n",
       "22           -1.019799          4.145361          5.256923    -0.981921   \n",
       "23           -5.179541        -15.316260        -11.919983    -9.698780   \n",
       "24          -11.293921        -16.976490         -9.640509   -15.414480   \n",
       "25           -9.304875         -1.903768          0.366303     1.333530   \n",
       "26            0.723305          1.277916         -1.322743     3.562759   \n",
       "27           -3.776059         -4.398151         -3.411525    -3.214258   \n",
       "28            2.089784         -1.910834         -1.831387    -0.469324   \n",
       "29           -0.704556         -4.425954          0.355208    -4.952081   \n",
       "...                ...               ...               ...          ...   \n",
       "3163          0.785682         -2.291512          1.646635    -0.409007   \n",
       "3164          2.146999          0.124593          0.757866     0.064031   \n",
       "3165         -2.261294          6.408289         -0.306872     3.302976   \n",
       "3166         -2.365078         -4.466572         -5.978395     5.340182   \n",
       "3167          2.998287          0.786996         -2.384388     0.741268   \n",
       "3168         -4.967343         -7.080338         -5.774236    -3.708191   \n",
       "3169          9.651174          4.547821         -4.577788     0.323325   \n",
       "3170          2.611880         -3.362825         -3.475492     6.570965   \n",
       "3171          2.720741         17.827111         -8.522727     4.782442   \n",
       "3172         15.621197         -5.701978         -7.811043    -2.413455   \n",
       "3173        -12.890117          3.431840         -2.591247    -7.266294   \n",
       "3174         15.581605         19.067123        -20.976314   -12.782801   \n",
       "3175         -4.207574          1.119116          8.329863    -1.124464   \n",
       "3176          7.832195         -4.672840        -11.546694     2.969819   \n",
       "3177          4.106475         -8.000587         -6.201093    15.102721   \n",
       "3178          6.007872          2.473972         -5.376344     5.201290   \n",
       "3179         -3.945918         -0.928721         -8.956092     5.466705   \n",
       "3180         15.566320          4.694442         -1.787905    -0.779195   \n",
       "3181        -11.578068         14.288867          5.529504    -9.811802   \n",
       "3182         23.120269         24.288458          0.233463     7.690181   \n",
       "3183          1.209921         27.866242        -39.106145    -0.402010   \n",
       "3184          8.101690          7.626081         -9.390640     6.204939   \n",
       "3185          5.506166          2.404121          6.615718     4.257768   \n",
       "3186          8.458886          4.509203          3.574531     2.122452   \n",
       "3187         15.385364        -40.684911        -16.580620   -21.514884   \n",
       "3188         16.195058         -5.292294        -12.991188     1.300672   \n",
       "3189          1.065160         19.283559         14.038186     0.935191   \n",
       "3190         -5.345297         -7.139457        -14.641707   -17.991433   \n",
       "3191         -0.946354         -1.776094        -16.813737   -11.995061   \n",
       "3192         -8.054829         13.093981          2.229188   -12.052414   \n",
       "\n",
       "      RNETMIG2012  RNETMIG2013  RNETMIG2014  \n",
       "0        1.001333     1.562247     1.577963  \n",
       "1       -2.589008    -2.701037     2.533226  \n",
       "2       19.260182    23.460897    20.538283  \n",
       "3       -2.426738    -7.054869    -2.190662  \n",
       "4       -4.980826    -6.601976    -0.222173  \n",
       "5       -1.022158    -1.524232    -1.767167  \n",
       "6       -3.488591    -0.471832    13.290280  \n",
       "7      -11.391019    -5.012531     0.246396  \n",
       "8       -4.178297    -5.217890    -3.785549  \n",
       "9        4.728966     4.219038    -1.641002  \n",
       "10       1.420618     5.946444     0.383494  \n",
       "11      -2.446889     0.708207     0.569690  \n",
       "12      -0.515407    -8.087253    -1.122754  \n",
       "13     -17.257683     0.198673    -8.062102  \n",
       "14     -13.189890     4.671684     6.061054  \n",
       "15      -5.086164     6.146651     3.588398  \n",
       "16      11.998190   -10.031545    -0.491304  \n",
       "17       1.689530     2.404287     2.384402  \n",
       "18      -7.575178    -6.176891   -14.940551  \n",
       "19     -11.276360    -4.495190   -16.035716  \n",
       "20      -4.455694     0.766597     4.197244  \n",
       "21       5.379043     0.000000     4.581737  \n",
       "22      -0.621829     4.654222     5.787551  \n",
       "23      -0.577718   -12.640407    -9.584311  \n",
       "24     -11.015059   -16.599757    -9.258707  \n",
       "25      -8.461533    -0.874323     1.451123  \n",
       "26       1.421668     1.786600    -0.852984  \n",
       "27      -3.618723    -4.240134    -3.226404  \n",
       "28       2.617023    -1.305897    -1.224138  \n",
       "29      -0.645843    -4.307928     0.473611  \n",
       "...           ...          ...          ...  \n",
       "3163     1.140750    -1.884467     2.067692  \n",
       "3164     2.981802     1.042510     1.677950  \n",
       "3165    -2.031332     6.657713    -0.057539  \n",
       "3166    -1.957306    -3.974840    -5.483632  \n",
       "3167     3.426613     1.278129    -1.888624  \n",
       "3168    -4.591436    -6.662261    -5.340490  \n",
       "3169    10.610525     5.406356    -3.746865  \n",
       "3170     5.412246    -0.133445    -0.265305  \n",
       "3171     2.550695    17.658930    -8.606283  \n",
       "3172    16.086869    -5.119294    -7.230913  \n",
       "3173   -12.699622     3.686050    -2.275241  \n",
       "3174    15.725879    19.349599   -20.694752  \n",
       "3175    -3.786816     1.538784     8.746356  \n",
       "3176     7.954573    -4.502476   -11.375451  \n",
       "3177     4.693114    -7.266588    -5.462867  \n",
       "3178     7.872385     4.535615    -3.308519  \n",
       "3179    -3.481692    -0.348270    -8.374527  \n",
       "3180    18.041567     6.046190    -0.727636  \n",
       "3181   -11.578068    14.288867     5.583715  \n",
       "3182    23.636059    24.826533     0.761825  \n",
       "3183     1.209921    27.866242   -39.106145  \n",
       "3184     9.323928     8.937352    -8.014722  \n",
       "3185     5.276742     2.175157     6.387590  \n",
       "3186     9.512000     5.619679     4.676956  \n",
       "3187    17.819758   -38.148202   -13.899921  \n",
       "3188    16.307213    -5.093003   -12.702987  \n",
       "3189     2.778678    21.234602    16.068867  \n",
       "3190    -5.774829    -7.520228   -15.023250  \n",
       "3191    -1.064648    -1.894500   -16.813737  \n",
       "3192    -8.337455    12.812390     1.950540  \n",
       "\n",
       "[3193 rows x 84 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop2014"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RINTERNATIONALMIG2013</th>\n",
       "      <th>RINTERNATIONALMIG2014</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>000</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736</td>\n",
       "      <td>4780127</td>\n",
       "      <td>4785822</td>\n",
       "      <td>...</td>\n",
       "      <td>1.165832</td>\n",
       "      <td>1.157861</td>\n",
       "      <td>-0.020443</td>\n",
       "      <td>-0.168414</td>\n",
       "      <td>0.396416</td>\n",
       "      <td>0.420102</td>\n",
       "      <td>1.011941</td>\n",
       "      <td>1.001333</td>\n",
       "      <td>1.562247</td>\n",
       "      <td>1.577963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>02</td>\n",
       "      <td>000</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>710231</td>\n",
       "      <td>710249</td>\n",
       "      <td>713856</td>\n",
       "      <td>...</td>\n",
       "      <td>3.203618</td>\n",
       "      <td>2.869760</td>\n",
       "      <td>-1.175137</td>\n",
       "      <td>-1.949571</td>\n",
       "      <td>-3.789313</td>\n",
       "      <td>-13.754494</td>\n",
       "      <td>0.948185</td>\n",
       "      <td>1.835376</td>\n",
       "      <td>-0.585695</td>\n",
       "      <td>-10.884734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>04</td>\n",
       "      <td>000</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>6392017</td>\n",
       "      <td>6392310</td>\n",
       "      <td>6411999</td>\n",
       "      <td>...</td>\n",
       "      <td>2.141877</td>\n",
       "      <td>2.129805</td>\n",
       "      <td>1.369514</td>\n",
       "      <td>5.131282</td>\n",
       "      <td>3.910476</td>\n",
       "      <td>6.280636</td>\n",
       "      <td>3.336628</td>\n",
       "      <td>7.155212</td>\n",
       "      <td>6.052353</td>\n",
       "      <td>8.410441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>05</td>\n",
       "      <td>000</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2915918</td>\n",
       "      <td>2915958</td>\n",
       "      <td>2922297</td>\n",
       "      <td>...</td>\n",
       "      <td>1.090035</td>\n",
       "      <td>1.091283</td>\n",
       "      <td>1.341472</td>\n",
       "      <td>-0.420875</td>\n",
       "      <td>-0.580562</td>\n",
       "      <td>-1.313050</td>\n",
       "      <td>2.317801</td>\n",
       "      <td>0.621971</td>\n",
       "      <td>0.509473</td>\n",
       "      <td>-0.221767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>06</td>\n",
       "      <td>000</td>\n",
       "      <td>California</td>\n",
       "      <td>California</td>\n",
       "      <td>37253956</td>\n",
       "      <td>37254503</td>\n",
       "      <td>37336011</td>\n",
       "      <td>...</td>\n",
       "      <td>4.207353</td>\n",
       "      <td>4.177389</td>\n",
       "      <td>-1.162079</td>\n",
       "      <td>-1.173951</td>\n",
       "      <td>-1.341226</td>\n",
       "      <td>-0.830982</td>\n",
       "      <td>2.761377</td>\n",
       "      <td>2.772770</td>\n",
       "      <td>2.866127</td>\n",
       "      <td>3.346406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>08</td>\n",
       "      <td>000</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>5029196</td>\n",
       "      <td>5029324</td>\n",
       "      <td>5048575</td>\n",
       "      <td>...</td>\n",
       "      <td>2.074200</td>\n",
       "      <td>2.010735</td>\n",
       "      <td>5.183397</td>\n",
       "      <td>5.553675</td>\n",
       "      <td>6.977583</td>\n",
       "      <td>7.587163</td>\n",
       "      <td>6.933159</td>\n",
       "      <td>7.660864</td>\n",
       "      <td>9.051783</td>\n",
       "      <td>9.597898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>09</td>\n",
       "      <td>000</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3574097</td>\n",
       "      <td>3574096</td>\n",
       "      <td>3579345</td>\n",
       "      <td>...</td>\n",
       "      <td>4.753602</td>\n",
       "      <td>4.730950</td>\n",
       "      <td>-3.384435</td>\n",
       "      <td>-5.611492</td>\n",
       "      <td>-4.731638</td>\n",
       "      <td>-7.286252</td>\n",
       "      <td>1.116894</td>\n",
       "      <td>-1.059166</td>\n",
       "      <td>0.021964</td>\n",
       "      <td>-2.555302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>000</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>897934</td>\n",
       "      <td>897936</td>\n",
       "      <td>899731</td>\n",
       "      <td>...</td>\n",
       "      <td>2.608949</td>\n",
       "      <td>2.565489</td>\n",
       "      <td>2.866848</td>\n",
       "      <td>3.598380</td>\n",
       "      <td>3.397171</td>\n",
       "      <td>5.148174</td>\n",
       "      <td>5.303282</td>\n",
       "      <td>6.221263</td>\n",
       "      <td>6.006120</td>\n",
       "      <td>7.713663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>000</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>601723</td>\n",
       "      <td>601767</td>\n",
       "      <td>605210</td>\n",
       "      <td>...</td>\n",
       "      <td>5.871584</td>\n",
       "      <td>5.749218</td>\n",
       "      <td>11.332882</td>\n",
       "      <td>10.005838</td>\n",
       "      <td>9.777666</td>\n",
       "      <td>1.793572</td>\n",
       "      <td>16.805955</td>\n",
       "      <td>15.595790</td>\n",
       "      <td>15.649250</td>\n",
       "      <td>7.542790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>000</td>\n",
       "      <td>Florida</td>\n",
       "      <td>Florida</td>\n",
       "      <td>18801310</td>\n",
       "      <td>18804623</td>\n",
       "      <td>18852220</td>\n",
       "      <td>...</td>\n",
       "      <td>5.783717</td>\n",
       "      <td>5.687300</td>\n",
       "      <td>5.540393</td>\n",
       "      <td>5.125320</td>\n",
       "      <td>4.918783</td>\n",
       "      <td>7.016123</td>\n",
       "      <td>11.359606</td>\n",
       "      <td>10.722573</td>\n",
       "      <td>10.702501</td>\n",
       "      <td>12.703423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>000</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>9687653</td>\n",
       "      <td>9688681</td>\n",
       "      <td>9714464</td>\n",
       "      <td>...</td>\n",
       "      <td>2.510526</td>\n",
       "      <td>2.470423</td>\n",
       "      <td>1.105816</td>\n",
       "      <td>1.852201</td>\n",
       "      <td>-0.576888</td>\n",
       "      <td>2.200467</td>\n",
       "      <td>3.375007</td>\n",
       "      <td>4.426268</td>\n",
       "      <td>1.933638</td>\n",
       "      <td>4.670890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>557</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>000</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1360301</td>\n",
       "      <td>1360301</td>\n",
       "      <td>1363950</td>\n",
       "      <td>...</td>\n",
       "      <td>6.426691</td>\n",
       "      <td>6.074495</td>\n",
       "      <td>-0.728612</td>\n",
       "      <td>-2.567288</td>\n",
       "      <td>-0.663156</td>\n",
       "      <td>-3.635081</td>\n",
       "      <td>4.254976</td>\n",
       "      <td>4.316105</td>\n",
       "      <td>5.763534</td>\n",
       "      <td>2.439414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>000</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>1567582</td>\n",
       "      <td>1567652</td>\n",
       "      <td>1570639</td>\n",
       "      <td>...</td>\n",
       "      <td>1.052850</td>\n",
       "      <td>1.043942</td>\n",
       "      <td>0.058331</td>\n",
       "      <td>-0.163554</td>\n",
       "      <td>2.986505</td>\n",
       "      <td>4.738696</td>\n",
       "      <td>0.952949</td>\n",
       "      <td>0.848596</td>\n",
       "      <td>4.039355</td>\n",
       "      <td>5.782638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>608</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>000</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>12830632</td>\n",
       "      <td>12831587</td>\n",
       "      <td>12840097</td>\n",
       "      <td>...</td>\n",
       "      <td>2.505015</td>\n",
       "      <td>2.518554</td>\n",
       "      <td>-5.424762</td>\n",
       "      <td>-5.690472</td>\n",
       "      <td>-5.238098</td>\n",
       "      <td>-7.369176</td>\n",
       "      <td>-3.182714</td>\n",
       "      <td>-3.382339</td>\n",
       "      <td>-2.733083</td>\n",
       "      <td>-4.850621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>18</td>\n",
       "      <td>000</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>6483802</td>\n",
       "      <td>6484192</td>\n",
       "      <td>6490308</td>\n",
       "      <td>...</td>\n",
       "      <td>1.586775</td>\n",
       "      <td>1.590575</td>\n",
       "      <td>-1.302543</td>\n",
       "      <td>-1.954162</td>\n",
       "      <td>-0.231150</td>\n",
       "      <td>-1.192172</td>\n",
       "      <td>0.155918</td>\n",
       "      <td>-0.507730</td>\n",
       "      <td>1.355625</td>\n",
       "      <td>0.398403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>19</td>\n",
       "      <td>000</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>3046355</td>\n",
       "      <td>3046869</td>\n",
       "      <td>3050295</td>\n",
       "      <td>...</td>\n",
       "      <td>1.732413</td>\n",
       "      <td>1.731762</td>\n",
       "      <td>0.091575</td>\n",
       "      <td>-1.398832</td>\n",
       "      <td>0.150123</td>\n",
       "      <td>-0.261313</td>\n",
       "      <td>1.684655</td>\n",
       "      <td>0.189551</td>\n",
       "      <td>1.882536</td>\n",
       "      <td>1.470449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>000</td>\n",
       "      <td>Kansas</td>\n",
       "      <td>Kansas</td>\n",
       "      <td>2853118</td>\n",
       "      <td>2853132</td>\n",
       "      <td>2858949</td>\n",
       "      <td>...</td>\n",
       "      <td>2.106968</td>\n",
       "      <td>2.050753</td>\n",
       "      <td>-3.156968</td>\n",
       "      <td>-1.789806</td>\n",
       "      <td>-4.369598</td>\n",
       "      <td>-4.760146</td>\n",
       "      <td>-1.406549</td>\n",
       "      <td>0.474641</td>\n",
       "      <td>-2.262630</td>\n",
       "      <td>-2.709393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>000</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4339367</td>\n",
       "      <td>4339349</td>\n",
       "      <td>4349838</td>\n",
       "      <td>...</td>\n",
       "      <td>1.394732</td>\n",
       "      <td>1.356853</td>\n",
       "      <td>0.597027</td>\n",
       "      <td>-1.271262</td>\n",
       "      <td>-0.542181</td>\n",
       "      <td>-0.858954</td>\n",
       "      <td>1.778007</td>\n",
       "      <td>0.199920</td>\n",
       "      <td>0.852551</td>\n",
       "      <td>0.497899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1131</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>000</td>\n",
       "      <td>Louisiana</td>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4533372</td>\n",
       "      <td>4533479</td>\n",
       "      <td>4545581</td>\n",
       "      <td>...</td>\n",
       "      <td>1.651933</td>\n",
       "      <td>1.620656</td>\n",
       "      <td>0.454747</td>\n",
       "      <td>-0.167961</td>\n",
       "      <td>-0.496858</td>\n",
       "      <td>-1.311569</td>\n",
       "      <td>1.940240</td>\n",
       "      <td>1.525589</td>\n",
       "      <td>1.155076</td>\n",
       "      <td>0.309086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1196</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>000</td>\n",
       "      <td>Maine</td>\n",
       "      <td>Maine</td>\n",
       "      <td>1328361</td>\n",
       "      <td>1328361</td>\n",
       "      <td>1327361</td>\n",
       "      <td>...</td>\n",
       "      <td>1.045424</td>\n",
       "      <td>1.035809</td>\n",
       "      <td>0.061763</td>\n",
       "      <td>-0.467529</td>\n",
       "      <td>-1.102625</td>\n",
       "      <td>0.399430</td>\n",
       "      <td>0.951308</td>\n",
       "      <td>0.534533</td>\n",
       "      <td>-0.057201</td>\n",
       "      <td>1.435239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1213</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>000</td>\n",
       "      <td>Maryland</td>\n",
       "      <td>Maryland</td>\n",
       "      <td>5773552</td>\n",
       "      <td>5773785</td>\n",
       "      <td>5788101</td>\n",
       "      <td>...</td>\n",
       "      <td>4.914731</td>\n",
       "      <td>4.860034</td>\n",
       "      <td>0.062930</td>\n",
       "      <td>-1.432047</td>\n",
       "      <td>-1.513876</td>\n",
       "      <td>-2.567321</td>\n",
       "      <td>4.604050</td>\n",
       "      <td>3.278216</td>\n",
       "      <td>3.400855</td>\n",
       "      <td>2.292713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1238</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>000</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6547629</td>\n",
       "      <td>6547817</td>\n",
       "      <td>6564073</td>\n",
       "      <td>...</td>\n",
       "      <td>5.589799</td>\n",
       "      <td>5.542473</td>\n",
       "      <td>-0.523666</td>\n",
       "      <td>-1.631583</td>\n",
       "      <td>-0.325484</td>\n",
       "      <td>-2.431048</td>\n",
       "      <td>4.789037</td>\n",
       "      <td>3.646943</td>\n",
       "      <td>5.264315</td>\n",
       "      <td>3.111426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1253</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>26</td>\n",
       "      <td>000</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9883640</td>\n",
       "      <td>9884133</td>\n",
       "      <td>9876498</td>\n",
       "      <td>...</td>\n",
       "      <td>2.029017</td>\n",
       "      <td>2.028870</td>\n",
       "      <td>-4.371657</td>\n",
       "      <td>-3.394243</td>\n",
       "      <td>-2.986811</td>\n",
       "      <td>-2.895688</td>\n",
       "      <td>-2.546041</td>\n",
       "      <td>-1.522632</td>\n",
       "      <td>-0.957793</td>\n",
       "      <td>-0.866818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>000</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5303925</td>\n",
       "      <td>5303925</td>\n",
       "      <td>5310418</td>\n",
       "      <td>...</td>\n",
       "      <td>2.583619</td>\n",
       "      <td>2.574079</td>\n",
       "      <td>-0.628046</td>\n",
       "      <td>-1.657431</td>\n",
       "      <td>-0.414342</td>\n",
       "      <td>-1.230969</td>\n",
       "      <td>1.733460</td>\n",
       "      <td>0.748277</td>\n",
       "      <td>2.169278</td>\n",
       "      <td>1.343109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1425</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>000</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2967297</td>\n",
       "      <td>2968103</td>\n",
       "      <td>2970811</td>\n",
       "      <td>...</td>\n",
       "      <td>0.784164</td>\n",
       "      <td>0.751718</td>\n",
       "      <td>-1.960911</td>\n",
       "      <td>-1.889481</td>\n",
       "      <td>-1.605462</td>\n",
       "      <td>-3.134498</td>\n",
       "      <td>-1.337642</td>\n",
       "      <td>-0.966703</td>\n",
       "      <td>-0.821298</td>\n",
       "      <td>-2.382780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>29</td>\n",
       "      <td>000</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>5988927</td>\n",
       "      <td>5988923</td>\n",
       "      <td>5996085</td>\n",
       "      <td>...</td>\n",
       "      <td>1.454160</td>\n",
       "      <td>1.427261</td>\n",
       "      <td>-2.245426</td>\n",
       "      <td>-2.240644</td>\n",
       "      <td>-1.348777</td>\n",
       "      <td>-1.333608</td>\n",
       "      <td>-0.987954</td>\n",
       "      <td>-0.800444</td>\n",
       "      <td>0.105384</td>\n",
       "      <td>0.093653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1624</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>30</td>\n",
       "      <td>000</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Montana</td>\n",
       "      <td>989415</td>\n",
       "      <td>989417</td>\n",
       "      <td>990575</td>\n",
       "      <td>...</td>\n",
       "      <td>0.792069</td>\n",
       "      <td>0.751554</td>\n",
       "      <td>3.434200</td>\n",
       "      <td>3.550986</td>\n",
       "      <td>5.297949</td>\n",
       "      <td>4.464192</td>\n",
       "      <td>4.040768</td>\n",
       "      <td>4.416764</td>\n",
       "      <td>6.090018</td>\n",
       "      <td>5.215746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "      <td>000</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1826341</td>\n",
       "      <td>1826341</td>\n",
       "      <td>1829865</td>\n",
       "      <td>...</td>\n",
       "      <td>2.056139</td>\n",
       "      <td>2.029078</td>\n",
       "      <td>-0.644863</td>\n",
       "      <td>-0.491654</td>\n",
       "      <td>-0.478459</td>\n",
       "      <td>-1.360362</td>\n",
       "      <td>1.169359</td>\n",
       "      <td>1.514447</td>\n",
       "      <td>1.577680</td>\n",
       "      <td>0.668716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1775</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>32</td>\n",
       "      <td>000</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>2700551</td>\n",
       "      <td>2700692</td>\n",
       "      <td>2703493</td>\n",
       "      <td>...</td>\n",
       "      <td>3.032412</td>\n",
       "      <td>3.003591</td>\n",
       "      <td>-2.827329</td>\n",
       "      <td>5.284416</td>\n",
       "      <td>4.755226</td>\n",
       "      <td>8.390946</td>\n",
       "      <td>-0.080781</td>\n",
       "      <td>8.145301</td>\n",
       "      <td>7.787639</td>\n",
       "      <td>11.394537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>000</td>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1316470</td>\n",
       "      <td>1316466</td>\n",
       "      <td>1316517</td>\n",
       "      <td>...</td>\n",
       "      <td>1.536359</td>\n",
       "      <td>1.529386</td>\n",
       "      <td>-1.636665</td>\n",
       "      <td>-0.398575</td>\n",
       "      <td>-1.986450</td>\n",
       "      <td>0.843201</td>\n",
       "      <td>-0.302889</td>\n",
       "      <td>1.045690</td>\n",
       "      <td>-0.450090</td>\n",
       "      <td>2.372587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1804</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>000</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8791894</td>\n",
       "      <td>8791936</td>\n",
       "      <td>8803580</td>\n",
       "      <td>...</td>\n",
       "      <td>5.799240</td>\n",
       "      <td>5.784530</td>\n",
       "      <td>-5.110337</td>\n",
       "      <td>-5.589038</td>\n",
       "      <td>-5.120562</td>\n",
       "      <td>-6.215126</td>\n",
       "      <td>0.454262</td>\n",
       "      <td>-0.199000</td>\n",
       "      <td>0.678679</td>\n",
       "      <td>-0.430596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1826</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "      <td>000</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2059179</td>\n",
       "      <td>2059192</td>\n",
       "      <td>2064950</td>\n",
       "      <td>...</td>\n",
       "      <td>1.283954</td>\n",
       "      <td>1.280777</td>\n",
       "      <td>0.030893</td>\n",
       "      <td>-3.420129</td>\n",
       "      <td>-5.062940</td>\n",
       "      <td>-6.784475</td>\n",
       "      <td>1.098143</td>\n",
       "      <td>-2.078308</td>\n",
       "      <td>-3.778986</td>\n",
       "      <td>-5.503698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1860</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>000</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York</td>\n",
       "      <td>19378102</td>\n",
       "      <td>19378112</td>\n",
       "      <td>19400867</td>\n",
       "      <td>...</td>\n",
       "      <td>6.051932</td>\n",
       "      <td>6.023999</td>\n",
       "      <td>-4.325455</td>\n",
       "      <td>-5.946809</td>\n",
       "      <td>-5.482049</td>\n",
       "      <td>-7.804947</td>\n",
       "      <td>1.494350</td>\n",
       "      <td>-0.318997</td>\n",
       "      <td>0.569883</td>\n",
       "      <td>-1.780948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1923</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>37</td>\n",
       "      <td>000</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>9535483</td>\n",
       "      <td>9535691</td>\n",
       "      <td>9559488</td>\n",
       "      <td>...</td>\n",
       "      <td>2.260641</td>\n",
       "      <td>2.140972</td>\n",
       "      <td>3.172143</td>\n",
       "      <td>3.299538</td>\n",
       "      <td>3.886902</td>\n",
       "      <td>3.663640</td>\n",
       "      <td>5.047944</td>\n",
       "      <td>5.772981</td>\n",
       "      <td>6.147543</td>\n",
       "      <td>5.804612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>38</td>\n",
       "      <td>000</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>672591</td>\n",
       "      <td>672591</td>\n",
       "      <td>674345</td>\n",
       "      <td>...</td>\n",
       "      <td>1.915034</td>\n",
       "      <td>1.763091</td>\n",
       "      <td>9.145424</td>\n",
       "      <td>15.589637</td>\n",
       "      <td>23.189451</td>\n",
       "      <td>12.265101</td>\n",
       "      <td>10.679714</td>\n",
       "      <td>17.804574</td>\n",
       "      <td>25.104485</td>\n",
       "      <td>14.028192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2078</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>39</td>\n",
       "      <td>000</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>11536504</td>\n",
       "      <td>11536725</td>\n",
       "      <td>11540070</td>\n",
       "      <td>...</td>\n",
       "      <td>1.518581</td>\n",
       "      <td>1.513932</td>\n",
       "      <td>-3.188588</td>\n",
       "      <td>-3.204065</td>\n",
       "      <td>-1.912303</td>\n",
       "      <td>-1.574969</td>\n",
       "      <td>-1.819983</td>\n",
       "      <td>-1.762236</td>\n",
       "      <td>-0.393722</td>\n",
       "      <td>-0.061037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2167</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>40</td>\n",
       "      <td>000</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3751351</td>\n",
       "      <td>3751616</td>\n",
       "      <td>3759481</td>\n",
       "      <td>...</td>\n",
       "      <td>1.508701</td>\n",
       "      <td>1.472222</td>\n",
       "      <td>1.674263</td>\n",
       "      <td>2.350733</td>\n",
       "      <td>3.599656</td>\n",
       "      <td>1.132300</td>\n",
       "      <td>3.007153</td>\n",
       "      <td>3.955502</td>\n",
       "      <td>5.108357</td>\n",
       "      <td>2.604522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2245</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>000</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>3831074</td>\n",
       "      <td>3831073</td>\n",
       "      <td>3837083</td>\n",
       "      <td>...</td>\n",
       "      <td>1.728175</td>\n",
       "      <td>1.737588</td>\n",
       "      <td>2.957665</td>\n",
       "      <td>3.376113</td>\n",
       "      <td>2.489666</td>\n",
       "      <td>5.740471</td>\n",
       "      <td>4.528908</td>\n",
       "      <td>4.932576</td>\n",
       "      <td>4.217842</td>\n",
       "      <td>7.478058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2282</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>000</td>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12702379</td>\n",
       "      <td>12702884</td>\n",
       "      <td>12711077</td>\n",
       "      <td>...</td>\n",
       "      <td>2.272758</td>\n",
       "      <td>2.273109</td>\n",
       "      <td>-0.546767</td>\n",
       "      <td>-1.358703</td>\n",
       "      <td>-2.483940</td>\n",
       "      <td>-2.459901</td>\n",
       "      <td>1.578782</td>\n",
       "      <td>0.797051</td>\n",
       "      <td>-0.211183</td>\n",
       "      <td>-0.186792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2350</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>000</td>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>1052567</td>\n",
       "      <td>1052931</td>\n",
       "      <td>1053078</td>\n",
       "      <td>...</td>\n",
       "      <td>4.106380</td>\n",
       "      <td>4.069191</td>\n",
       "      <td>-5.839158</td>\n",
       "      <td>-5.025997</td>\n",
       "      <td>-4.874665</td>\n",
       "      <td>-3.212669</td>\n",
       "      <td>-2.058812</td>\n",
       "      <td>-1.031997</td>\n",
       "      <td>-0.768284</td>\n",
       "      <td>0.856522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2356</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>000</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4625364</td>\n",
       "      <td>4625401</td>\n",
       "      <td>4636290</td>\n",
       "      <td>...</td>\n",
       "      <td>1.379318</td>\n",
       "      <td>1.310648</td>\n",
       "      <td>3.191202</td>\n",
       "      <td>5.613008</td>\n",
       "      <td>5.954363</td>\n",
       "      <td>8.040889</td>\n",
       "      <td>4.292891</td>\n",
       "      <td>7.229497</td>\n",
       "      <td>7.333681</td>\n",
       "      <td>9.351536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2403</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>000</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>814180</td>\n",
       "      <td>814191</td>\n",
       "      <td>816192</td>\n",
       "      <td>...</td>\n",
       "      <td>1.751176</td>\n",
       "      <td>1.706026</td>\n",
       "      <td>2.449458</td>\n",
       "      <td>5.243945</td>\n",
       "      <td>5.197576</td>\n",
       "      <td>0.661688</td>\n",
       "      <td>3.990580</td>\n",
       "      <td>7.059852</td>\n",
       "      <td>6.948752</td>\n",
       "      <td>2.367714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2470</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>47</td>\n",
       "      <td>000</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6346105</td>\n",
       "      <td>6346275</td>\n",
       "      <td>6356628</td>\n",
       "      <td>...</td>\n",
       "      <td>1.417493</td>\n",
       "      <td>1.404195</td>\n",
       "      <td>2.452525</td>\n",
       "      <td>4.286281</td>\n",
       "      <td>2.089798</td>\n",
       "      <td>3.757448</td>\n",
       "      <td>3.696271</td>\n",
       "      <td>5.729927</td>\n",
       "      <td>3.507291</td>\n",
       "      <td>5.161643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2566</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>000</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Texas</td>\n",
       "      <td>25145561</td>\n",
       "      <td>25146104</td>\n",
       "      <td>25245717</td>\n",
       "      <td>...</td>\n",
       "      <td>3.201213</td>\n",
       "      <td>3.166214</td>\n",
       "      <td>4.577945</td>\n",
       "      <td>5.630982</td>\n",
       "      <td>4.428284</td>\n",
       "      <td>5.778507</td>\n",
       "      <td>7.675275</td>\n",
       "      <td>8.724163</td>\n",
       "      <td>7.629497</td>\n",
       "      <td>8.944721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>49</td>\n",
       "      <td>000</td>\n",
       "      <td>Utah</td>\n",
       "      <td>Utah</td>\n",
       "      <td>2763885</td>\n",
       "      <td>2763885</td>\n",
       "      <td>2774346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.888857</td>\n",
       "      <td>1.869754</td>\n",
       "      <td>-0.328821</td>\n",
       "      <td>-0.030685</td>\n",
       "      <td>1.920812</td>\n",
       "      <td>-0.422534</td>\n",
       "      <td>1.419762</td>\n",
       "      <td>1.759980</td>\n",
       "      <td>3.809669</td>\n",
       "      <td>1.447220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2851</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>000</td>\n",
       "      <td>Vermont</td>\n",
       "      <td>Vermont</td>\n",
       "      <td>625741</td>\n",
       "      <td>625745</td>\n",
       "      <td>625792</td>\n",
       "      <td>...</td>\n",
       "      <td>1.150844</td>\n",
       "      <td>1.147264</td>\n",
       "      <td>-0.752251</td>\n",
       "      <td>-2.604208</td>\n",
       "      <td>-1.098171</td>\n",
       "      <td>-2.471644</td>\n",
       "      <td>0.255542</td>\n",
       "      <td>-1.516859</td>\n",
       "      <td>0.052674</td>\n",
       "      <td>-1.324380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2866</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>51</td>\n",
       "      <td>000</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>8001024</td>\n",
       "      <td>8001023</td>\n",
       "      <td>8025376</td>\n",
       "      <td>...</td>\n",
       "      <td>4.195152</td>\n",
       "      <td>4.098421</td>\n",
       "      <td>1.331717</td>\n",
       "      <td>0.603915</td>\n",
       "      <td>0.304183</td>\n",
       "      <td>-2.458330</td>\n",
       "      <td>4.975221</td>\n",
       "      <td>5.003800</td>\n",
       "      <td>4.499335</td>\n",
       "      <td>1.640092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3000</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>53</td>\n",
       "      <td>000</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Washington</td>\n",
       "      <td>6724540</td>\n",
       "      <td>6724543</td>\n",
       "      <td>6741911</td>\n",
       "      <td>...</td>\n",
       "      <td>3.455210</td>\n",
       "      <td>3.396158</td>\n",
       "      <td>3.446470</td>\n",
       "      <td>1.962177</td>\n",
       "      <td>2.250746</td>\n",
       "      <td>3.998925</td>\n",
       "      <td>6.416385</td>\n",
       "      <td>5.370291</td>\n",
       "      <td>5.705957</td>\n",
       "      <td>7.395083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3040</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>54</td>\n",
       "      <td>000</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1852994</td>\n",
       "      <td>1853033</td>\n",
       "      <td>1854176</td>\n",
       "      <td>...</td>\n",
       "      <td>0.631283</td>\n",
       "      <td>0.628523</td>\n",
       "      <td>0.586117</td>\n",
       "      <td>0.562068</td>\n",
       "      <td>-1.252861</td>\n",
       "      <td>-1.484373</td>\n",
       "      <td>1.143656</td>\n",
       "      <td>1.171559</td>\n",
       "      <td>-0.621579</td>\n",
       "      <td>-0.855850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3096</th>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>000</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5686986</td>\n",
       "      <td>5687289</td>\n",
       "      <td>5689268</td>\n",
       "      <td>...</td>\n",
       "      <td>1.129419</td>\n",
       "      <td>1.139079</td>\n",
       "      <td>-1.094924</td>\n",
       "      <td>-1.653887</td>\n",
       "      <td>-1.369743</td>\n",
       "      <td>-1.727053</td>\n",
       "      <td>-0.058431</td>\n",
       "      <td>-0.619224</td>\n",
       "      <td>-0.240324</td>\n",
       "      <td>-0.587974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3169</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>000</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626</td>\n",
       "      <td>563767</td>\n",
       "      <td>564358</td>\n",
       "      <td>...</td>\n",
       "      <td>0.858535</td>\n",
       "      <td>0.830923</td>\n",
       "      <td>-0.362194</td>\n",
       "      <td>9.651174</td>\n",
       "      <td>4.547821</td>\n",
       "      <td>-4.577788</td>\n",
       "      <td>0.323325</td>\n",
       "      <td>10.610525</td>\n",
       "      <td>5.406356</td>\n",
       "      <td>-3.746865</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SUMLEV  REGION  DIVISION STATE COUNTY                STNAME  \\\n",
       "0         40       3         6    01    000               Alabama   \n",
       "68        40       4         9    02    000                Alaska   \n",
       "98        40       4         8    04    000               Arizona   \n",
       "114       40       3         7    05    000              Arkansas   \n",
       "190       40       4         9    06    000            California   \n",
       "249       40       4         8    08    000              Colorado   \n",
       "314       40       1         1    09    000           Connecticut   \n",
       "323       40       3         5    10    000              Delaware   \n",
       "327       40       3         5    11    000  District of Columbia   \n",
       "329       40       3         5    12    000               Florida   \n",
       "397       40       3         5    13    000               Georgia   \n",
       "557       40       4         9    15    000                Hawaii   \n",
       "563       40       4         8    16    000                 Idaho   \n",
       "608       40       2         3    17    000              Illinois   \n",
       "711       40       2         3    18    000               Indiana   \n",
       "804       40       2         4    19    000                  Iowa   \n",
       "904       40       2         4    20    000                Kansas   \n",
       "1010      40       3         6    21    000              Kentucky   \n",
       "1131      40       3         7    22    000             Louisiana   \n",
       "1196      40       1         1    23    000                 Maine   \n",
       "1213      40       3         5    24    000              Maryland   \n",
       "1238      40       1         1    25    000         Massachusetts   \n",
       "1253      40       2         3    26    000              Michigan   \n",
       "1337      40       2         4    27    000             Minnesota   \n",
       "1425      40       3         6    28    000           Mississippi   \n",
       "1508      40       2         4    29    000              Missouri   \n",
       "1624      40       4         8    30    000               Montana   \n",
       "1681      40       2         4    31    000              Nebraska   \n",
       "1775      40       4         8    32    000                Nevada   \n",
       "1793      40       1         1    33    000         New Hampshire   \n",
       "1804      40       1         2    34    000            New Jersey   \n",
       "1826      40       4         8    35    000            New Mexico   \n",
       "1860      40       1         2    36    000              New York   \n",
       "1923      40       3         5    37    000        North Carolina   \n",
       "2024      40       2         4    38    000          North Dakota   \n",
       "2078      40       2         3    39    000                  Ohio   \n",
       "2167      40       3         7    40    000              Oklahoma   \n",
       "2245      40       4         9    41    000                Oregon   \n",
       "2282      40       1         2    42    000          Pennsylvania   \n",
       "2350      40       1         1    44    000          Rhode Island   \n",
       "2356      40       3         5    45    000        South Carolina   \n",
       "2403      40       2         4    46    000          South Dakota   \n",
       "2470      40       3         6    47    000             Tennessee   \n",
       "2566      40       3         7    48    000                 Texas   \n",
       "2821      40       4         8    49    000                  Utah   \n",
       "2851      40       1         1    50    000               Vermont   \n",
       "2866      40       3         5    51    000              Virginia   \n",
       "3000      40       4         9    53    000            Washington   \n",
       "3040      40       3         5    54    000         West Virginia   \n",
       "3096      40       2         3    55    000             Wisconsin   \n",
       "3169      40       4         8    56    000               Wyoming   \n",
       "\n",
       "                   CTYNAME  CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010  \\\n",
       "0                  Alabama        4779736            4780127          4785822   \n",
       "68                  Alaska         710231             710249           713856   \n",
       "98                 Arizona        6392017            6392310          6411999   \n",
       "114               Arkansas        2915918            2915958          2922297   \n",
       "190             California       37253956           37254503         37336011   \n",
       "249               Colorado        5029196            5029324          5048575   \n",
       "314            Connecticut        3574097            3574096          3579345   \n",
       "323               Delaware         897934             897936           899731   \n",
       "327   District of Columbia         601723             601767           605210   \n",
       "329                Florida       18801310           18804623         18852220   \n",
       "397                Georgia        9687653            9688681          9714464   \n",
       "557                 Hawaii        1360301            1360301          1363950   \n",
       "563                  Idaho        1567582            1567652          1570639   \n",
       "608               Illinois       12830632           12831587         12840097   \n",
       "711                Indiana        6483802            6484192          6490308   \n",
       "804                   Iowa        3046355            3046869          3050295   \n",
       "904                 Kansas        2853118            2853132          2858949   \n",
       "1010              Kentucky        4339367            4339349          4349838   \n",
       "1131             Louisiana        4533372            4533479          4545581   \n",
       "1196                 Maine        1328361            1328361          1327361   \n",
       "1213              Maryland        5773552            5773785          5788101   \n",
       "1238         Massachusetts        6547629            6547817          6564073   \n",
       "1253              Michigan        9883640            9884133          9876498   \n",
       "1337             Minnesota        5303925            5303925          5310418   \n",
       "1425           Mississippi        2967297            2968103          2970811   \n",
       "1508              Missouri        5988927            5988923          5996085   \n",
       "1624               Montana         989415             989417           990575   \n",
       "1681              Nebraska        1826341            1826341          1829865   \n",
       "1775                Nevada        2700551            2700692          2703493   \n",
       "1793         New Hampshire        1316470            1316466          1316517   \n",
       "1804            New Jersey        8791894            8791936          8803580   \n",
       "1826            New Mexico        2059179            2059192          2064950   \n",
       "1860              New York       19378102           19378112         19400867   \n",
       "1923        North Carolina        9535483            9535691          9559488   \n",
       "2024          North Dakota         672591             672591           674345   \n",
       "2078                  Ohio       11536504           11536725         11540070   \n",
       "2167              Oklahoma        3751351            3751616          3759481   \n",
       "2245                Oregon        3831074            3831073          3837083   \n",
       "2282          Pennsylvania       12702379           12702884         12711077   \n",
       "2350          Rhode Island        1052567            1052931          1053078   \n",
       "2356        South Carolina        4625364            4625401          4636290   \n",
       "2403          South Dakota         814180             814191           816192   \n",
       "2470             Tennessee        6346105            6346275          6356628   \n",
       "2566                 Texas       25145561           25146104         25245717   \n",
       "2821                  Utah        2763885            2763885          2774346   \n",
       "2851               Vermont         625741             625745           625792   \n",
       "2866              Virginia        8001024            8001023          8025376   \n",
       "3000            Washington        6724540            6724543          6741911   \n",
       "3040         West Virginia        1852994            1853033          1854176   \n",
       "3096             Wisconsin        5686986            5687289          5689268   \n",
       "3169               Wyoming         563626             563767           564358   \n",
       "\n",
       "         ...       RINTERNATIONALMIG2013  RINTERNATIONALMIG2014  \\\n",
       "0        ...                    1.165832               1.157861   \n",
       "68       ...                    3.203618               2.869760   \n",
       "98       ...                    2.141877               2.129805   \n",
       "114      ...                    1.090035               1.091283   \n",
       "190      ...                    4.207353               4.177389   \n",
       "249      ...                    2.074200               2.010735   \n",
       "314      ...                    4.753602               4.730950   \n",
       "323      ...                    2.608949               2.565489   \n",
       "327      ...                    5.871584               5.749218   \n",
       "329      ...                    5.783717               5.687300   \n",
       "397      ...                    2.510526               2.470423   \n",
       "557      ...                    6.426691               6.074495   \n",
       "563      ...                    1.052850               1.043942   \n",
       "608      ...                    2.505015               2.518554   \n",
       "711      ...                    1.586775               1.590575   \n",
       "804      ...                    1.732413               1.731762   \n",
       "904      ...                    2.106968               2.050753   \n",
       "1010     ...                    1.394732               1.356853   \n",
       "1131     ...                    1.651933               1.620656   \n",
       "1196     ...                    1.045424               1.035809   \n",
       "1213     ...                    4.914731               4.860034   \n",
       "1238     ...                    5.589799               5.542473   \n",
       "1253     ...                    2.029017               2.028870   \n",
       "1337     ...                    2.583619               2.574079   \n",
       "1425     ...                    0.784164               0.751718   \n",
       "1508     ...                    1.454160               1.427261   \n",
       "1624     ...                    0.792069               0.751554   \n",
       "1681     ...                    2.056139               2.029078   \n",
       "1775     ...                    3.032412               3.003591   \n",
       "1793     ...                    1.536359               1.529386   \n",
       "1804     ...                    5.799240               5.784530   \n",
       "1826     ...                    1.283954               1.280777   \n",
       "1860     ...                    6.051932               6.023999   \n",
       "1923     ...                    2.260641               2.140972   \n",
       "2024     ...                    1.915034               1.763091   \n",
       "2078     ...                    1.518581               1.513932   \n",
       "2167     ...                    1.508701               1.472222   \n",
       "2245     ...                    1.728175               1.737588   \n",
       "2282     ...                    2.272758               2.273109   \n",
       "2350     ...                    4.106380               4.069191   \n",
       "2356     ...                    1.379318               1.310648   \n",
       "2403     ...                    1.751176               1.706026   \n",
       "2470     ...                    1.417493               1.404195   \n",
       "2566     ...                    3.201213               3.166214   \n",
       "2821     ...                    1.888857               1.869754   \n",
       "2851     ...                    1.150844               1.147264   \n",
       "2866     ...                    4.195152               4.098421   \n",
       "3000     ...                    3.455210               3.396158   \n",
       "3040     ...                    0.631283               0.628523   \n",
       "3096     ...                    1.129419               1.139079   \n",
       "3169     ...                    0.858535               0.830923   \n",
       "\n",
       "      RDOMESTICMIG2011  RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  \\\n",
       "0            -0.020443         -0.168414          0.396416          0.420102   \n",
       "68           -1.175137         -1.949571         -3.789313        -13.754494   \n",
       "98            1.369514          5.131282          3.910476          6.280636   \n",
       "114           1.341472         -0.420875         -0.580562         -1.313050   \n",
       "190          -1.162079         -1.173951         -1.341226         -0.830982   \n",
       "249           5.183397          5.553675          6.977583          7.587163   \n",
       "314          -3.384435         -5.611492         -4.731638         -7.286252   \n",
       "323           2.866848          3.598380          3.397171          5.148174   \n",
       "327          11.332882         10.005838          9.777666          1.793572   \n",
       "329           5.540393          5.125320          4.918783          7.016123   \n",
       "397           1.105816          1.852201         -0.576888          2.200467   \n",
       "557          -0.728612         -2.567288         -0.663156         -3.635081   \n",
       "563           0.058331         -0.163554          2.986505          4.738696   \n",
       "608          -5.424762         -5.690472         -5.238098         -7.369176   \n",
       "711          -1.302543         -1.954162         -0.231150         -1.192172   \n",
       "804           0.091575         -1.398832          0.150123         -0.261313   \n",
       "904          -3.156968         -1.789806         -4.369598         -4.760146   \n",
       "1010          0.597027         -1.271262         -0.542181         -0.858954   \n",
       "1131          0.454747         -0.167961         -0.496858         -1.311569   \n",
       "1196          0.061763         -0.467529         -1.102625          0.399430   \n",
       "1213          0.062930         -1.432047         -1.513876         -2.567321   \n",
       "1238         -0.523666         -1.631583         -0.325484         -2.431048   \n",
       "1253         -4.371657         -3.394243         -2.986811         -2.895688   \n",
       "1337         -0.628046         -1.657431         -0.414342         -1.230969   \n",
       "1425         -1.960911         -1.889481         -1.605462         -3.134498   \n",
       "1508         -2.245426         -2.240644         -1.348777         -1.333608   \n",
       "1624          3.434200          3.550986          5.297949          4.464192   \n",
       "1681         -0.644863         -0.491654         -0.478459         -1.360362   \n",
       "1775         -2.827329          5.284416          4.755226          8.390946   \n",
       "1793         -1.636665         -0.398575         -1.986450          0.843201   \n",
       "1804         -5.110337         -5.589038         -5.120562         -6.215126   \n",
       "1826          0.030893         -3.420129         -5.062940         -6.784475   \n",
       "1860         -4.325455         -5.946809         -5.482049         -7.804947   \n",
       "1923          3.172143          3.299538          3.886902          3.663640   \n",
       "2024          9.145424         15.589637         23.189451         12.265101   \n",
       "2078         -3.188588         -3.204065         -1.912303         -1.574969   \n",
       "2167          1.674263          2.350733          3.599656          1.132300   \n",
       "2245          2.957665          3.376113          2.489666          5.740471   \n",
       "2282         -0.546767         -1.358703         -2.483940         -2.459901   \n",
       "2350         -5.839158         -5.025997         -4.874665         -3.212669   \n",
       "2356          3.191202          5.613008          5.954363          8.040889   \n",
       "2403          2.449458          5.243945          5.197576          0.661688   \n",
       "2470          2.452525          4.286281          2.089798          3.757448   \n",
       "2566          4.577945          5.630982          4.428284          5.778507   \n",
       "2821         -0.328821         -0.030685          1.920812         -0.422534   \n",
       "2851         -0.752251         -2.604208         -1.098171         -2.471644   \n",
       "2866          1.331717          0.603915          0.304183         -2.458330   \n",
       "3000          3.446470          1.962177          2.250746          3.998925   \n",
       "3040          0.586117          0.562068         -1.252861         -1.484373   \n",
       "3096         -1.094924         -1.653887         -1.369743         -1.727053   \n",
       "3169         -0.362194          9.651174          4.547821         -4.577788   \n",
       "\n",
       "      RNETMIG2011  RNETMIG2012  RNETMIG2013  RNETMIG2014  \n",
       "0        1.011941     1.001333     1.562247     1.577963  \n",
       "68       0.948185     1.835376    -0.585695   -10.884734  \n",
       "98       3.336628     7.155212     6.052353     8.410441  \n",
       "114      2.317801     0.621971     0.509473    -0.221767  \n",
       "190      2.761377     2.772770     2.866127     3.346406  \n",
       "249      6.933159     7.660864     9.051783     9.597898  \n",
       "314      1.116894    -1.059166     0.021964    -2.555302  \n",
       "323      5.303282     6.221263     6.006120     7.713663  \n",
       "327     16.805955    15.595790    15.649250     7.542790  \n",
       "329     11.359606    10.722573    10.702501    12.703423  \n",
       "397      3.375007     4.426268     1.933638     4.670890  \n",
       "557      4.254976     4.316105     5.763534     2.439414  \n",
       "563      0.952949     0.848596     4.039355     5.782638  \n",
       "608     -3.182714    -3.382339    -2.733083    -4.850621  \n",
       "711      0.155918    -0.507730     1.355625     0.398403  \n",
       "804      1.684655     0.189551     1.882536     1.470449  \n",
       "904     -1.406549     0.474641    -2.262630    -2.709393  \n",
       "1010     1.778007     0.199920     0.852551     0.497899  \n",
       "1131     1.940240     1.525589     1.155076     0.309086  \n",
       "1196     0.951308     0.534533    -0.057201     1.435239  \n",
       "1213     4.604050     3.278216     3.400855     2.292713  \n",
       "1238     4.789037     3.646943     5.264315     3.111426  \n",
       "1253    -2.546041    -1.522632    -0.957793    -0.866818  \n",
       "1337     1.733460     0.748277     2.169278     1.343109  \n",
       "1425    -1.337642    -0.966703    -0.821298    -2.382780  \n",
       "1508    -0.987954    -0.800444     0.105384     0.093653  \n",
       "1624     4.040768     4.416764     6.090018     5.215746  \n",
       "1681     1.169359     1.514447     1.577680     0.668716  \n",
       "1775    -0.080781     8.145301     7.787639    11.394537  \n",
       "1793    -0.302889     1.045690    -0.450090     2.372587  \n",
       "1804     0.454262    -0.199000     0.678679    -0.430596  \n",
       "1826     1.098143    -2.078308    -3.778986    -5.503698  \n",
       "1860     1.494350    -0.318997     0.569883    -1.780948  \n",
       "1923     5.047944     5.772981     6.147543     5.804612  \n",
       "2024    10.679714    17.804574    25.104485    14.028192  \n",
       "2078    -1.819983    -1.762236    -0.393722    -0.061037  \n",
       "2167     3.007153     3.955502     5.108357     2.604522  \n",
       "2245     4.528908     4.932576     4.217842     7.478058  \n",
       "2282     1.578782     0.797051    -0.211183    -0.186792  \n",
       "2350    -2.058812    -1.031997    -0.768284     0.856522  \n",
       "2356     4.292891     7.229497     7.333681     9.351536  \n",
       "2403     3.990580     7.059852     6.948752     2.367714  \n",
       "2470     3.696271     5.729927     3.507291     5.161643  \n",
       "2566     7.675275     8.724163     7.629497     8.944721  \n",
       "2821     1.419762     1.759980     3.809669     1.447220  \n",
       "2851     0.255542    -1.516859     0.052674    -1.324380  \n",
       "2866     4.975221     5.003800     4.499335     1.640092  \n",
       "3000     6.416385     5.370291     5.705957     7.395083  \n",
       "3040     1.143656     1.171559    -0.621579    -0.855850  \n",
       "3096    -0.058431    -0.619224    -0.240324    -0.587974  \n",
       "3169     0.323325    10.610525     5.406356    -3.746865  \n",
       "\n",
       "[51 rows x 84 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop2014_by_state = pop2014[pop2014.SUMLEV == 40]\n",
    "pop2014_by_state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "require.config({\n",
       "    paths: {\n",
       "        d3: '//cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min'\n",
       "    }\n",
       "});"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%javascript\n",
    "require.config({\n",
    "    paths: {\n",
    "        d3: '//cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min'\n",
    "    }\n",
    "});\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from IPython.core.display import display, Javascript, HTML\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RINTERNATIONALMIG2013</th>\n",
       "      <th>RINTERNATIONALMIG2014</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>001</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Autauga County</td>\n",
       "      <td>54571</td>\n",
       "      <td>54571</td>\n",
       "      <td>54684</td>\n",
       "      <td>...</td>\n",
       "      <td>0.217533</td>\n",
       "      <td>0.199039</td>\n",
       "      <td>7.239062</td>\n",
       "      <td>-2.806268</td>\n",
       "      <td>-2.918570</td>\n",
       "      <td>2.334187</td>\n",
       "      <td>7.530079</td>\n",
       "      <td>-2.589008</td>\n",
       "      <td>-2.701037</td>\n",
       "      <td>2.533226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>003</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>182265</td>\n",
       "      <td>182265</td>\n",
       "      <td>183216</td>\n",
       "      <td>...</td>\n",
       "      <td>1.471487</td>\n",
       "      <td>1.430905</td>\n",
       "      <td>14.554892</td>\n",
       "      <td>17.834091</td>\n",
       "      <td>21.989409</td>\n",
       "      <td>19.107379</td>\n",
       "      <td>15.890352</td>\n",
       "      <td>19.260182</td>\n",
       "      <td>23.460897</td>\n",
       "      <td>20.538283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>005</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Barbour County</td>\n",
       "      <td>27457</td>\n",
       "      <td>27457</td>\n",
       "      <td>27336</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.036936</td>\n",
       "      <td>0.037130</td>\n",
       "      <td>-4.765309</td>\n",
       "      <td>-2.389969</td>\n",
       "      <td>-7.017933</td>\n",
       "      <td>-2.227792</td>\n",
       "      <td>-4.618684</td>\n",
       "      <td>-2.426738</td>\n",
       "      <td>-7.054869</td>\n",
       "      <td>-2.190662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>007</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bibb County</td>\n",
       "      <td>22915</td>\n",
       "      <td>22919</td>\n",
       "      <td>22879</td>\n",
       "      <td>...</td>\n",
       "      <td>0.132926</td>\n",
       "      <td>0.133304</td>\n",
       "      <td>-5.611697</td>\n",
       "      <td>-4.980826</td>\n",
       "      <td>-6.734902</td>\n",
       "      <td>-0.355477</td>\n",
       "      <td>-5.567855</td>\n",
       "      <td>-4.980826</td>\n",
       "      <td>-6.601976</td>\n",
       "      <td>-0.222173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>009</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Blount County</td>\n",
       "      <td>57322</td>\n",
       "      <td>57322</td>\n",
       "      <td>57344</td>\n",
       "      <td>...</td>\n",
       "      <td>0.190529</td>\n",
       "      <td>0.207902</td>\n",
       "      <td>1.773327</td>\n",
       "      <td>-1.143431</td>\n",
       "      <td>-1.714761</td>\n",
       "      <td>-1.975069</td>\n",
       "      <td>2.034110</td>\n",
       "      <td>-1.022158</td>\n",
       "      <td>-1.524232</td>\n",
       "      <td>-1.767167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>011</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bullock County</td>\n",
       "      <td>10914</td>\n",
       "      <td>10915</td>\n",
       "      <td>10886</td>\n",
       "      <td>...</td>\n",
       "      <td>1.226762</td>\n",
       "      <td>1.310309</td>\n",
       "      <td>-30.963783</td>\n",
       "      <td>-4.714313</td>\n",
       "      <td>-1.698594</td>\n",
       "      <td>11.979971</td>\n",
       "      <td>-29.476033</td>\n",
       "      <td>-3.488591</td>\n",
       "      <td>-0.471832</td>\n",
       "      <td>13.290280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>013</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Butler County</td>\n",
       "      <td>20947</td>\n",
       "      <td>20946</td>\n",
       "      <td>20945</td>\n",
       "      <td>...</td>\n",
       "      <td>0.294855</td>\n",
       "      <td>0.295676</td>\n",
       "      <td>-14.079431</td>\n",
       "      <td>-11.683096</td>\n",
       "      <td>-5.307386</td>\n",
       "      <td>-0.049279</td>\n",
       "      <td>-13.791115</td>\n",
       "      <td>-11.391019</td>\n",
       "      <td>-5.012531</td>\n",
       "      <td>0.246396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>015</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun County</td>\n",
       "      <td>118572</td>\n",
       "      <td>118586</td>\n",
       "      <td>118443</td>\n",
       "      <td>...</td>\n",
       "      <td>0.282279</td>\n",
       "      <td>0.266709</td>\n",
       "      <td>-6.147255</td>\n",
       "      <td>-4.544217</td>\n",
       "      <td>-5.500169</td>\n",
       "      <td>-4.052258</td>\n",
       "      <td>-5.918638</td>\n",
       "      <td>-4.178297</td>\n",
       "      <td>-5.217890</td>\n",
       "      <td>-3.785549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>017</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chambers County</td>\n",
       "      <td>34215</td>\n",
       "      <td>34170</td>\n",
       "      <td>34111</td>\n",
       "      <td>...</td>\n",
       "      <td>0.937564</td>\n",
       "      <td>0.937715</td>\n",
       "      <td>-2.730676</td>\n",
       "      <td>3.877164</td>\n",
       "      <td>3.281474</td>\n",
       "      <td>-2.578717</td>\n",
       "      <td>-1.820451</td>\n",
       "      <td>4.728966</td>\n",
       "      <td>4.219038</td>\n",
       "      <td>-1.641002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>019</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cherokee County</td>\n",
       "      <td>25989</td>\n",
       "      <td>25986</td>\n",
       "      <td>25968</td>\n",
       "      <td>...</td>\n",
       "      <td>0.191821</td>\n",
       "      <td>0.191747</td>\n",
       "      <td>6.302723</td>\n",
       "      <td>1.228643</td>\n",
       "      <td>5.754623</td>\n",
       "      <td>0.191747</td>\n",
       "      <td>6.494879</td>\n",
       "      <td>1.420618</td>\n",
       "      <td>5.946444</td>\n",
       "      <td>0.383494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>021</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chilton County</td>\n",
       "      <td>43643</td>\n",
       "      <td>43631</td>\n",
       "      <td>43682</td>\n",
       "      <td>...</td>\n",
       "      <td>0.365526</td>\n",
       "      <td>0.432965</td>\n",
       "      <td>-1.372511</td>\n",
       "      <td>-2.744174</td>\n",
       "      <td>0.342681</td>\n",
       "      <td>0.136726</td>\n",
       "      <td>-0.960758</td>\n",
       "      <td>-2.446889</td>\n",
       "      <td>0.708207</td>\n",
       "      <td>0.569690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>023</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Choctaw County</td>\n",
       "      <td>13859</td>\n",
       "      <td>13858</td>\n",
       "      <td>13849</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222585</td>\n",
       "      <td>0.224551</td>\n",
       "      <td>-15.517430</td>\n",
       "      <td>-0.736296</td>\n",
       "      <td>-8.309838</td>\n",
       "      <td>-1.347305</td>\n",
       "      <td>-15.298874</td>\n",
       "      <td>-0.515407</td>\n",
       "      <td>-8.087253</td>\n",
       "      <td>-1.122754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>025</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clarke County</td>\n",
       "      <td>25833</td>\n",
       "      <td>25840</td>\n",
       "      <td>25782</td>\n",
       "      <td>...</td>\n",
       "      <td>0.397346</td>\n",
       "      <td>0.399114</td>\n",
       "      <td>-6.228832</td>\n",
       "      <td>-17.612293</td>\n",
       "      <td>-0.198673</td>\n",
       "      <td>-8.461216</td>\n",
       "      <td>-5.878460</td>\n",
       "      <td>-17.257683</td>\n",
       "      <td>0.198673</td>\n",
       "      <td>-8.062102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay County</td>\n",
       "      <td>13932</td>\n",
       "      <td>13932</td>\n",
       "      <td>13886</td>\n",
       "      <td>...</td>\n",
       "      <td>0.148307</td>\n",
       "      <td>0.147831</td>\n",
       "      <td>-10.739034</td>\n",
       "      <td>-13.263577</td>\n",
       "      <td>4.523377</td>\n",
       "      <td>5.913223</td>\n",
       "      <td>-10.666473</td>\n",
       "      <td>-13.189890</td>\n",
       "      <td>4.671684</td>\n",
       "      <td>6.061054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>029</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cleburne County</td>\n",
       "      <td>14972</td>\n",
       "      <td>14972</td>\n",
       "      <td>14969</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-3.674506</td>\n",
       "      <td>-5.086164</td>\n",
       "      <td>6.146651</td>\n",
       "      <td>3.588398</td>\n",
       "      <td>-3.674506</td>\n",
       "      <td>-5.086164</td>\n",
       "      <td>6.146651</td>\n",
       "      <td>3.588398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>031</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coffee County</td>\n",
       "      <td>49948</td>\n",
       "      <td>49948</td>\n",
       "      <td>50179</td>\n",
       "      <td>...</td>\n",
       "      <td>3.154451</td>\n",
       "      <td>2.928171</td>\n",
       "      <td>0.377568</td>\n",
       "      <td>7.690643</td>\n",
       "      <td>-13.185995</td>\n",
       "      <td>-3.419475</td>\n",
       "      <td>2.484003</td>\n",
       "      <td>11.998190</td>\n",
       "      <td>-10.031545</td>\n",
       "      <td>-0.491304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>033</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Colbert County</td>\n",
       "      <td>54428</td>\n",
       "      <td>54428</td>\n",
       "      <td>54505</td>\n",
       "      <td>...</td>\n",
       "      <td>0.605660</td>\n",
       "      <td>0.623613</td>\n",
       "      <td>-0.128513</td>\n",
       "      <td>1.101868</td>\n",
       "      <td>1.798627</td>\n",
       "      <td>1.760789</td>\n",
       "      <td>0.477336</td>\n",
       "      <td>1.689530</td>\n",
       "      <td>2.404287</td>\n",
       "      <td>2.384402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>035</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Conecuh County</td>\n",
       "      <td>13228</td>\n",
       "      <td>13228</td>\n",
       "      <td>13219</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-4.933212</td>\n",
       "      <td>-7.575178</td>\n",
       "      <td>-6.176891</td>\n",
       "      <td>-14.940551</td>\n",
       "      <td>-4.933212</td>\n",
       "      <td>-7.575178</td>\n",
       "      <td>-6.176891</td>\n",
       "      <td>-14.940551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>037</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coosa County</td>\n",
       "      <td>11539</td>\n",
       "      <td>11758</td>\n",
       "      <td>11757</td>\n",
       "      <td>...</td>\n",
       "      <td>0.089904</td>\n",
       "      <td>0.091112</td>\n",
       "      <td>-34.370806</td>\n",
       "      <td>-11.276360</td>\n",
       "      <td>-4.585094</td>\n",
       "      <td>-16.126828</td>\n",
       "      <td>-34.370806</td>\n",
       "      <td>-11.276360</td>\n",
       "      <td>-4.495190</td>\n",
       "      <td>-16.035716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>039</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Covington County</td>\n",
       "      <td>37765</td>\n",
       "      <td>37765</td>\n",
       "      <td>37784</td>\n",
       "      <td>...</td>\n",
       "      <td>0.211475</td>\n",
       "      <td>0.211182</td>\n",
       "      <td>6.672557</td>\n",
       "      <td>-4.640249</td>\n",
       "      <td>0.555122</td>\n",
       "      <td>3.986062</td>\n",
       "      <td>6.857173</td>\n",
       "      <td>-4.455694</td>\n",
       "      <td>0.766597</td>\n",
       "      <td>4.197244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>041</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Crenshaw County</td>\n",
       "      <td>13906</td>\n",
       "      <td>13906</td>\n",
       "      <td>13866</td>\n",
       "      <td>...</td>\n",
       "      <td>1.432049</td>\n",
       "      <td>1.503383</td>\n",
       "      <td>1.727862</td>\n",
       "      <td>4.088073</td>\n",
       "      <td>-1.432049</td>\n",
       "      <td>3.078355</td>\n",
       "      <td>3.023758</td>\n",
       "      <td>5.379043</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.581737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>043</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cullman County</td>\n",
       "      <td>80406</td>\n",
       "      <td>80410</td>\n",
       "      <td>80454</td>\n",
       "      <td>...</td>\n",
       "      <td>0.508862</td>\n",
       "      <td>0.530628</td>\n",
       "      <td>-1.416950</td>\n",
       "      <td>-1.019799</td>\n",
       "      <td>4.145361</td>\n",
       "      <td>5.256923</td>\n",
       "      <td>-0.981921</td>\n",
       "      <td>-0.621829</td>\n",
       "      <td>4.654222</td>\n",
       "      <td>5.787551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>045</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dale County</td>\n",
       "      <td>50251</td>\n",
       "      <td>50251</td>\n",
       "      <td>50340</td>\n",
       "      <td>...</td>\n",
       "      <td>2.675852</td>\n",
       "      <td>2.335672</td>\n",
       "      <td>-10.814040</td>\n",
       "      <td>-5.179541</td>\n",
       "      <td>-15.316260</td>\n",
       "      <td>-11.919983</td>\n",
       "      <td>-9.698780</td>\n",
       "      <td>-0.577718</td>\n",
       "      <td>-12.640407</td>\n",
       "      <td>-9.584311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>047</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dallas County</td>\n",
       "      <td>43820</td>\n",
       "      <td>43820</td>\n",
       "      <td>43836</td>\n",
       "      <td>...</td>\n",
       "      <td>0.376732</td>\n",
       "      <td>0.381802</td>\n",
       "      <td>-15.667176</td>\n",
       "      <td>-11.293921</td>\n",
       "      <td>-16.976490</td>\n",
       "      <td>-9.640509</td>\n",
       "      <td>-15.414480</td>\n",
       "      <td>-11.015059</td>\n",
       "      <td>-16.599757</td>\n",
       "      <td>-9.258707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>049</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>DeKalb County</td>\n",
       "      <td>71109</td>\n",
       "      <td>71115</td>\n",
       "      <td>71118</td>\n",
       "      <td>...</td>\n",
       "      <td>1.029445</td>\n",
       "      <td>1.084820</td>\n",
       "      <td>0.280743</td>\n",
       "      <td>-9.304875</td>\n",
       "      <td>-1.903768</td>\n",
       "      <td>0.366303</td>\n",
       "      <td>1.333530</td>\n",
       "      <td>-8.461533</td>\n",
       "      <td>-0.874323</td>\n",
       "      <td>1.451123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>051</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Elmore County</td>\n",
       "      <td>79303</td>\n",
       "      <td>79296</td>\n",
       "      <td>79444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.508685</td>\n",
       "      <td>0.469759</td>\n",
       "      <td>3.236591</td>\n",
       "      <td>0.723305</td>\n",
       "      <td>1.277916</td>\n",
       "      <td>-1.322743</td>\n",
       "      <td>3.562759</td>\n",
       "      <td>1.421668</td>\n",
       "      <td>1.786600</td>\n",
       "      <td>-0.852984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>053</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Escambia County</td>\n",
       "      <td>38319</td>\n",
       "      <td>38319</td>\n",
       "      <td>38312</td>\n",
       "      <td>...</td>\n",
       "      <td>0.158017</td>\n",
       "      <td>0.185122</td>\n",
       "      <td>-3.475579</td>\n",
       "      <td>-3.776059</td>\n",
       "      <td>-4.398151</td>\n",
       "      <td>-3.411525</td>\n",
       "      <td>-3.214258</td>\n",
       "      <td>-3.618723</td>\n",
       "      <td>-4.240134</td>\n",
       "      <td>-3.226404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>055</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Etowah County</td>\n",
       "      <td>104430</td>\n",
       "      <td>104427</td>\n",
       "      <td>104501</td>\n",
       "      <td>...</td>\n",
       "      <td>0.604937</td>\n",
       "      <td>0.607249</td>\n",
       "      <td>-1.005694</td>\n",
       "      <td>2.089784</td>\n",
       "      <td>-1.910834</td>\n",
       "      <td>-1.831387</td>\n",
       "      <td>-0.469324</td>\n",
       "      <td>2.617023</td>\n",
       "      <td>-1.305897</td>\n",
       "      <td>-1.224138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>057</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Fayette County</td>\n",
       "      <td>17241</td>\n",
       "      <td>17241</td>\n",
       "      <td>17247</td>\n",
       "      <td>...</td>\n",
       "      <td>0.118025</td>\n",
       "      <td>0.118403</td>\n",
       "      <td>-5.010341</td>\n",
       "      <td>-0.704556</td>\n",
       "      <td>-4.425954</td>\n",
       "      <td>0.355208</td>\n",
       "      <td>-4.952081</td>\n",
       "      <td>-0.645843</td>\n",
       "      <td>-4.307928</td>\n",
       "      <td>0.473611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>059</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Franklin County</td>\n",
       "      <td>31704</td>\n",
       "      <td>31709</td>\n",
       "      <td>31755</td>\n",
       "      <td>...</td>\n",
       "      <td>1.898674</td>\n",
       "      <td>1.995471</td>\n",
       "      <td>-1.637486</td>\n",
       "      <td>-5.645174</td>\n",
       "      <td>-7.942787</td>\n",
       "      <td>-1.076921</td>\n",
       "      <td>0.314901</td>\n",
       "      <td>-3.942161</td>\n",
       "      <td>-6.044113</td>\n",
       "      <td>0.918550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3162</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>129</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washburn County</td>\n",
       "      <td>15911</td>\n",
       "      <td>15911</td>\n",
       "      <td>15934</td>\n",
       "      <td>...</td>\n",
       "      <td>0.190428</td>\n",
       "      <td>0.191284</td>\n",
       "      <td>-6.872419</td>\n",
       "      <td>7.336664</td>\n",
       "      <td>-7.490161</td>\n",
       "      <td>4.016960</td>\n",
       "      <td>-6.746319</td>\n",
       "      <td>7.463159</td>\n",
       "      <td>-7.299733</td>\n",
       "      <td>4.208244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3163</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>131</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washington County</td>\n",
       "      <td>131887</td>\n",
       "      <td>131885</td>\n",
       "      <td>131897</td>\n",
       "      <td>...</td>\n",
       "      <td>0.407045</td>\n",
       "      <td>0.421057</td>\n",
       "      <td>-0.795292</td>\n",
       "      <td>0.785682</td>\n",
       "      <td>-2.291512</td>\n",
       "      <td>1.646635</td>\n",
       "      <td>-0.409007</td>\n",
       "      <td>1.140750</td>\n",
       "      <td>-1.884467</td>\n",
       "      <td>2.067692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3164</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>133</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waukesha County</td>\n",
       "      <td>389891</td>\n",
       "      <td>389938</td>\n",
       "      <td>390079</td>\n",
       "      <td>...</td>\n",
       "      <td>0.917918</td>\n",
       "      <td>0.920084</td>\n",
       "      <td>-0.768369</td>\n",
       "      <td>2.146999</td>\n",
       "      <td>0.124593</td>\n",
       "      <td>0.757866</td>\n",
       "      <td>0.064031</td>\n",
       "      <td>2.981802</td>\n",
       "      <td>1.042510</td>\n",
       "      <td>1.677950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3165</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>135</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waupaca County</td>\n",
       "      <td>52410</td>\n",
       "      <td>52410</td>\n",
       "      <td>52417</td>\n",
       "      <td>...</td>\n",
       "      <td>0.249424</td>\n",
       "      <td>0.249334</td>\n",
       "      <td>3.073868</td>\n",
       "      <td>-2.261294</td>\n",
       "      <td>6.408289</td>\n",
       "      <td>-0.306872</td>\n",
       "      <td>3.302976</td>\n",
       "      <td>-2.031332</td>\n",
       "      <td>6.657713</td>\n",
       "      <td>-0.057539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3166</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>137</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waushara County</td>\n",
       "      <td>24496</td>\n",
       "      <td>24496</td>\n",
       "      <td>24492</td>\n",
       "      <td>...</td>\n",
       "      <td>0.491733</td>\n",
       "      <td>0.494764</td>\n",
       "      <td>4.932534</td>\n",
       "      <td>-2.365078</td>\n",
       "      <td>-4.466572</td>\n",
       "      <td>-5.978395</td>\n",
       "      <td>5.340182</td>\n",
       "      <td>-1.957306</td>\n",
       "      <td>-3.974840</td>\n",
       "      <td>-5.483632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3167</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>139</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Winnebago County</td>\n",
       "      <td>166994</td>\n",
       "      <td>166994</td>\n",
       "      <td>167004</td>\n",
       "      <td>...</td>\n",
       "      <td>0.491133</td>\n",
       "      <td>0.495764</td>\n",
       "      <td>0.298898</td>\n",
       "      <td>2.998287</td>\n",
       "      <td>0.786996</td>\n",
       "      <td>-2.384388</td>\n",
       "      <td>0.741268</td>\n",
       "      <td>3.426613</td>\n",
       "      <td>1.278129</td>\n",
       "      <td>-1.888624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3168</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>141</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Wood County</td>\n",
       "      <td>74749</td>\n",
       "      <td>74749</td>\n",
       "      <td>74780</td>\n",
       "      <td>...</td>\n",
       "      <td>0.418077</td>\n",
       "      <td>0.433745</td>\n",
       "      <td>-4.056252</td>\n",
       "      <td>-4.967343</td>\n",
       "      <td>-7.080338</td>\n",
       "      <td>-5.774236</td>\n",
       "      <td>-3.708191</td>\n",
       "      <td>-4.591436</td>\n",
       "      <td>-6.662261</td>\n",
       "      <td>-5.340490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3170</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>001</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Albany County</td>\n",
       "      <td>36299</td>\n",
       "      <td>36299</td>\n",
       "      <td>36440</td>\n",
       "      <td>...</td>\n",
       "      <td>3.229379</td>\n",
       "      <td>3.210188</td>\n",
       "      <td>3.735362</td>\n",
       "      <td>2.611880</td>\n",
       "      <td>-3.362825</td>\n",
       "      <td>-3.475492</td>\n",
       "      <td>6.570965</td>\n",
       "      <td>5.412246</td>\n",
       "      <td>-0.133445</td>\n",
       "      <td>-0.265305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3171</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>003</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Big Horn County</td>\n",
       "      <td>11668</td>\n",
       "      <td>11668</td>\n",
       "      <td>11674</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.168180</td>\n",
       "      <td>-0.083556</td>\n",
       "      <td>4.867842</td>\n",
       "      <td>2.720741</td>\n",
       "      <td>17.827111</td>\n",
       "      <td>-8.522727</td>\n",
       "      <td>4.782442</td>\n",
       "      <td>2.550695</td>\n",
       "      <td>17.658930</td>\n",
       "      <td>-8.606283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3172</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>005</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Campbell County</td>\n",
       "      <td>46133</td>\n",
       "      <td>46133</td>\n",
       "      <td>46223</td>\n",
       "      <td>...</td>\n",
       "      <td>0.582684</td>\n",
       "      <td>0.580131</td>\n",
       "      <td>-2.844429</td>\n",
       "      <td>15.621197</td>\n",
       "      <td>-5.701978</td>\n",
       "      <td>-7.811043</td>\n",
       "      <td>-2.413455</td>\n",
       "      <td>16.086869</td>\n",
       "      <td>-5.119294</td>\n",
       "      <td>-7.230913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3173</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>007</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Carbon County</td>\n",
       "      <td>15885</td>\n",
       "      <td>15885</td>\n",
       "      <td>15835</td>\n",
       "      <td>...</td>\n",
       "      <td>0.254210</td>\n",
       "      <td>0.316006</td>\n",
       "      <td>-7.455849</td>\n",
       "      <td>-12.890117</td>\n",
       "      <td>3.431840</td>\n",
       "      <td>-2.591247</td>\n",
       "      <td>-7.266294</td>\n",
       "      <td>-12.699622</td>\n",
       "      <td>3.686050</td>\n",
       "      <td>-2.275241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3174</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>009</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Converse County</td>\n",
       "      <td>13833</td>\n",
       "      <td>13833</td>\n",
       "      <td>13817</td>\n",
       "      <td>...</td>\n",
       "      <td>0.282476</td>\n",
       "      <td>0.281561</td>\n",
       "      <td>-12.928060</td>\n",
       "      <td>15.581605</td>\n",
       "      <td>19.067123</td>\n",
       "      <td>-20.976314</td>\n",
       "      <td>-12.782801</td>\n",
       "      <td>15.725879</td>\n",
       "      <td>19.349599</td>\n",
       "      <td>-20.694752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3175</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>011</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Crook County</td>\n",
       "      <td>7083</td>\n",
       "      <td>7083</td>\n",
       "      <td>7108</td>\n",
       "      <td>...</td>\n",
       "      <td>0.419668</td>\n",
       "      <td>0.416493</td>\n",
       "      <td>-1.546138</td>\n",
       "      <td>-4.207574</td>\n",
       "      <td>1.119116</td>\n",
       "      <td>8.329863</td>\n",
       "      <td>-1.124464</td>\n",
       "      <td>-3.786816</td>\n",
       "      <td>1.538784</td>\n",
       "      <td>8.746356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3176</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>013</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Fremont County</td>\n",
       "      <td>40123</td>\n",
       "      <td>40123</td>\n",
       "      <td>40224</td>\n",
       "      <td>...</td>\n",
       "      <td>0.170364</td>\n",
       "      <td>0.171243</td>\n",
       "      <td>2.771831</td>\n",
       "      <td>7.832195</td>\n",
       "      <td>-4.672840</td>\n",
       "      <td>-11.546694</td>\n",
       "      <td>2.969819</td>\n",
       "      <td>7.954573</td>\n",
       "      <td>-4.502476</td>\n",
       "      <td>-11.375451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3177</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>015</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Goshen County</td>\n",
       "      <td>13249</td>\n",
       "      <td>13247</td>\n",
       "      <td>13411</td>\n",
       "      <td>...</td>\n",
       "      <td>0.733999</td>\n",
       "      <td>0.738225</td>\n",
       "      <td>14.510457</td>\n",
       "      <td>4.106475</td>\n",
       "      <td>-8.000587</td>\n",
       "      <td>-6.201093</td>\n",
       "      <td>15.102721</td>\n",
       "      <td>4.693114</td>\n",
       "      <td>-7.266588</td>\n",
       "      <td>-5.462867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3178</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>017</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Hot Springs County</td>\n",
       "      <td>4812</td>\n",
       "      <td>4812</td>\n",
       "      <td>4804</td>\n",
       "      <td>...</td>\n",
       "      <td>2.061643</td>\n",
       "      <td>2.067825</td>\n",
       "      <td>3.328826</td>\n",
       "      <td>6.007872</td>\n",
       "      <td>2.473972</td>\n",
       "      <td>-5.376344</td>\n",
       "      <td>5.201290</td>\n",
       "      <td>7.872385</td>\n",
       "      <td>4.535615</td>\n",
       "      <td>-3.308519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3179</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>019</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Johnson County</td>\n",
       "      <td>8569</td>\n",
       "      <td>8569</td>\n",
       "      <td>8568</td>\n",
       "      <td>...</td>\n",
       "      <td>0.580450</td>\n",
       "      <td>0.581564</td>\n",
       "      <td>5.001454</td>\n",
       "      <td>-3.945918</td>\n",
       "      <td>-0.928721</td>\n",
       "      <td>-8.956092</td>\n",
       "      <td>5.466705</td>\n",
       "      <td>-3.481692</td>\n",
       "      <td>-0.348270</td>\n",
       "      <td>-8.374527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3180</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>021</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Laramie County</td>\n",
       "      <td>91738</td>\n",
       "      <td>91881</td>\n",
       "      <td>92199</td>\n",
       "      <td>...</td>\n",
       "      <td>1.351748</td>\n",
       "      <td>1.060269</td>\n",
       "      <td>-1.190438</td>\n",
       "      <td>15.566320</td>\n",
       "      <td>4.694442</td>\n",
       "      <td>-1.787905</td>\n",
       "      <td>-0.779195</td>\n",
       "      <td>18.041567</td>\n",
       "      <td>6.046190</td>\n",
       "      <td>-0.727636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3181</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>023</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Lincoln County</td>\n",
       "      <td>18106</td>\n",
       "      <td>18106</td>\n",
       "      <td>18075</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.054211</td>\n",
       "      <td>-9.811802</td>\n",
       "      <td>-11.578068</td>\n",
       "      <td>14.288867</td>\n",
       "      <td>5.529504</td>\n",
       "      <td>-9.811802</td>\n",
       "      <td>-11.578068</td>\n",
       "      <td>14.288867</td>\n",
       "      <td>5.583715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3182</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>025</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Natrona County</td>\n",
       "      <td>75450</td>\n",
       "      <td>75450</td>\n",
       "      <td>75466</td>\n",
       "      <td>...</td>\n",
       "      <td>0.538075</td>\n",
       "      <td>0.528363</td>\n",
       "      <td>7.189792</td>\n",
       "      <td>23.120269</td>\n",
       "      <td>24.288458</td>\n",
       "      <td>0.233463</td>\n",
       "      <td>7.690181</td>\n",
       "      <td>23.636059</td>\n",
       "      <td>24.826533</td>\n",
       "      <td>0.761825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3183</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>027</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Niobrara County</td>\n",
       "      <td>2484</td>\n",
       "      <td>2484</td>\n",
       "      <td>2491</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.402010</td>\n",
       "      <td>1.209921</td>\n",
       "      <td>27.866242</td>\n",
       "      <td>-39.106145</td>\n",
       "      <td>-0.402010</td>\n",
       "      <td>1.209921</td>\n",
       "      <td>27.866242</td>\n",
       "      <td>-39.106145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3184</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>029</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Park County</td>\n",
       "      <td>28205</td>\n",
       "      <td>28205</td>\n",
       "      <td>28262</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311272</td>\n",
       "      <td>1.375918</td>\n",
       "      <td>4.618449</td>\n",
       "      <td>8.101690</td>\n",
       "      <td>7.626081</td>\n",
       "      <td>-9.390640</td>\n",
       "      <td>6.204939</td>\n",
       "      <td>9.323928</td>\n",
       "      <td>8.937352</td>\n",
       "      <td>-8.014722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3185</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>031</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Platte County</td>\n",
       "      <td>8667</td>\n",
       "      <td>8667</td>\n",
       "      <td>8680</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.228964</td>\n",
       "      <td>-0.228128</td>\n",
       "      <td>4.487917</td>\n",
       "      <td>5.506166</td>\n",
       "      <td>2.404121</td>\n",
       "      <td>6.615718</td>\n",
       "      <td>4.257768</td>\n",
       "      <td>5.276742</td>\n",
       "      <td>2.175157</td>\n",
       "      <td>6.387590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3186</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>033</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sheridan County</td>\n",
       "      <td>29116</td>\n",
       "      <td>29116</td>\n",
       "      <td>29148</td>\n",
       "      <td>...</td>\n",
       "      <td>1.110475</td>\n",
       "      <td>1.102425</td>\n",
       "      <td>0.958527</td>\n",
       "      <td>8.458886</td>\n",
       "      <td>4.509203</td>\n",
       "      <td>3.574531</td>\n",
       "      <td>2.122452</td>\n",
       "      <td>9.512000</td>\n",
       "      <td>5.619679</td>\n",
       "      <td>4.676956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3187</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>035</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sublette County</td>\n",
       "      <td>10247</td>\n",
       "      <td>10247</td>\n",
       "      <td>10231</td>\n",
       "      <td>...</td>\n",
       "      <td>2.536709</td>\n",
       "      <td>2.680699</td>\n",
       "      <td>-23.970921</td>\n",
       "      <td>15.385364</td>\n",
       "      <td>-40.684911</td>\n",
       "      <td>-16.580620</td>\n",
       "      <td>-21.514884</td>\n",
       "      <td>17.819758</td>\n",
       "      <td>-38.148202</td>\n",
       "      <td>-13.899921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3188</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>037</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sweetwater County</td>\n",
       "      <td>43806</td>\n",
       "      <td>43806</td>\n",
       "      <td>43599</td>\n",
       "      <td>...</td>\n",
       "      <td>0.199291</td>\n",
       "      <td>0.288200</td>\n",
       "      <td>1.072484</td>\n",
       "      <td>16.195058</td>\n",
       "      <td>-5.292294</td>\n",
       "      <td>-12.991188</td>\n",
       "      <td>1.300672</td>\n",
       "      <td>16.307213</td>\n",
       "      <td>-5.093003</td>\n",
       "      <td>-12.702987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3189</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>039</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Teton County</td>\n",
       "      <td>21294</td>\n",
       "      <td>21294</td>\n",
       "      <td>21290</td>\n",
       "      <td>...</td>\n",
       "      <td>1.951042</td>\n",
       "      <td>2.030681</td>\n",
       "      <td>-1.589825</td>\n",
       "      <td>1.065160</td>\n",
       "      <td>19.283559</td>\n",
       "      <td>14.038186</td>\n",
       "      <td>0.935191</td>\n",
       "      <td>2.778678</td>\n",
       "      <td>21.234602</td>\n",
       "      <td>16.068867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3190</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>041</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Uinta County</td>\n",
       "      <td>21118</td>\n",
       "      <td>21118</td>\n",
       "      <td>21103</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.380771</td>\n",
       "      <td>-0.381543</td>\n",
       "      <td>-17.563065</td>\n",
       "      <td>-5.345297</td>\n",
       "      <td>-7.139457</td>\n",
       "      <td>-14.641707</td>\n",
       "      <td>-17.991433</td>\n",
       "      <td>-5.774829</td>\n",
       "      <td>-7.520228</td>\n",
       "      <td>-15.023250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3191</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>043</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Washakie County</td>\n",
       "      <td>8533</td>\n",
       "      <td>8533</td>\n",
       "      <td>8541</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.118406</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-11.642265</td>\n",
       "      <td>-0.946354</td>\n",
       "      <td>-1.776094</td>\n",
       "      <td>-16.813737</td>\n",
       "      <td>-11.995061</td>\n",
       "      <td>-1.064648</td>\n",
       "      <td>-1.894500</td>\n",
       "      <td>-16.813737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3192</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>045</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>7208</td>\n",
       "      <td>7208</td>\n",
       "      <td>7169</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.281591</td>\n",
       "      <td>-0.278649</td>\n",
       "      <td>-11.772125</td>\n",
       "      <td>-8.054829</td>\n",
       "      <td>13.093981</td>\n",
       "      <td>2.229188</td>\n",
       "      <td>-12.052414</td>\n",
       "      <td>-8.337455</td>\n",
       "      <td>12.812390</td>\n",
       "      <td>1.950540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3142 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SUMLEV  REGION  DIVISION STATE COUNTY     STNAME             CTYNAME  \\\n",
       "1         50       3         6    01    001    Alabama      Autauga County   \n",
       "2         50       3         6    01    003    Alabama      Baldwin County   \n",
       "3         50       3         6    01    005    Alabama      Barbour County   \n",
       "4         50       3         6    01    007    Alabama         Bibb County   \n",
       "5         50       3         6    01    009    Alabama       Blount County   \n",
       "6         50       3         6    01    011    Alabama      Bullock County   \n",
       "7         50       3         6    01    013    Alabama       Butler County   \n",
       "8         50       3         6    01    015    Alabama      Calhoun County   \n",
       "9         50       3         6    01    017    Alabama     Chambers County   \n",
       "10        50       3         6    01    019    Alabama     Cherokee County   \n",
       "11        50       3         6    01    021    Alabama      Chilton County   \n",
       "12        50       3         6    01    023    Alabama      Choctaw County   \n",
       "13        50       3         6    01    025    Alabama       Clarke County   \n",
       "14        50       3         6    01    027    Alabama         Clay County   \n",
       "15        50       3         6    01    029    Alabama     Cleburne County   \n",
       "16        50       3         6    01    031    Alabama       Coffee County   \n",
       "17        50       3         6    01    033    Alabama      Colbert County   \n",
       "18        50       3         6    01    035    Alabama      Conecuh County   \n",
       "19        50       3         6    01    037    Alabama        Coosa County   \n",
       "20        50       3         6    01    039    Alabama    Covington County   \n",
       "21        50       3         6    01    041    Alabama     Crenshaw County   \n",
       "22        50       3         6    01    043    Alabama      Cullman County   \n",
       "23        50       3         6    01    045    Alabama         Dale County   \n",
       "24        50       3         6    01    047    Alabama       Dallas County   \n",
       "25        50       3         6    01    049    Alabama       DeKalb County   \n",
       "26        50       3         6    01    051    Alabama       Elmore County   \n",
       "27        50       3         6    01    053    Alabama     Escambia County   \n",
       "28        50       3         6    01    055    Alabama       Etowah County   \n",
       "29        50       3         6    01    057    Alabama      Fayette County   \n",
       "30        50       3         6    01    059    Alabama     Franklin County   \n",
       "...      ...     ...       ...   ...    ...        ...                 ...   \n",
       "3162      50       2         3    55    129  Wisconsin     Washburn County   \n",
       "3163      50       2         3    55    131  Wisconsin   Washington County   \n",
       "3164      50       2         3    55    133  Wisconsin     Waukesha County   \n",
       "3165      50       2         3    55    135  Wisconsin      Waupaca County   \n",
       "3166      50       2         3    55    137  Wisconsin     Waushara County   \n",
       "3167      50       2         3    55    139  Wisconsin    Winnebago County   \n",
       "3168      50       2         3    55    141  Wisconsin         Wood County   \n",
       "3170      50       4         8    56    001    Wyoming       Albany County   \n",
       "3171      50       4         8    56    003    Wyoming     Big Horn County   \n",
       "3172      50       4         8    56    005    Wyoming     Campbell County   \n",
       "3173      50       4         8    56    007    Wyoming       Carbon County   \n",
       "3174      50       4         8    56    009    Wyoming     Converse County   \n",
       "3175      50       4         8    56    011    Wyoming        Crook County   \n",
       "3176      50       4         8    56    013    Wyoming      Fremont County   \n",
       "3177      50       4         8    56    015    Wyoming       Goshen County   \n",
       "3178      50       4         8    56    017    Wyoming  Hot Springs County   \n",
       "3179      50       4         8    56    019    Wyoming      Johnson County   \n",
       "3180      50       4         8    56    021    Wyoming      Laramie County   \n",
       "3181      50       4         8    56    023    Wyoming      Lincoln County   \n",
       "3182      50       4         8    56    025    Wyoming      Natrona County   \n",
       "3183      50       4         8    56    027    Wyoming     Niobrara County   \n",
       "3184      50       4         8    56    029    Wyoming         Park County   \n",
       "3185      50       4         8    56    031    Wyoming       Platte County   \n",
       "3186      50       4         8    56    033    Wyoming     Sheridan County   \n",
       "3187      50       4         8    56    035    Wyoming     Sublette County   \n",
       "3188      50       4         8    56    037    Wyoming   Sweetwater County   \n",
       "3189      50       4         8    56    039    Wyoming        Teton County   \n",
       "3190      50       4         8    56    041    Wyoming        Uinta County   \n",
       "3191      50       4         8    56    043    Wyoming     Washakie County   \n",
       "3192      50       4         8    56    045    Wyoming       Weston County   \n",
       "\n",
       "      CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010     ...       \\\n",
       "1             54571              54571            54684     ...        \n",
       "2            182265             182265           183216     ...        \n",
       "3             27457              27457            27336     ...        \n",
       "4             22915              22919            22879     ...        \n",
       "5             57322              57322            57344     ...        \n",
       "6             10914              10915            10886     ...        \n",
       "7             20947              20946            20945     ...        \n",
       "8            118572             118586           118443     ...        \n",
       "9             34215              34170            34111     ...        \n",
       "10            25989              25986            25968     ...        \n",
       "11            43643              43631            43682     ...        \n",
       "12            13859              13858            13849     ...        \n",
       "13            25833              25840            25782     ...        \n",
       "14            13932              13932            13886     ...        \n",
       "15            14972              14972            14969     ...        \n",
       "16            49948              49948            50179     ...        \n",
       "17            54428              54428            54505     ...        \n",
       "18            13228              13228            13219     ...        \n",
       "19            11539              11758            11757     ...        \n",
       "20            37765              37765            37784     ...        \n",
       "21            13906              13906            13866     ...        \n",
       "22            80406              80410            80454     ...        \n",
       "23            50251              50251            50340     ...        \n",
       "24            43820              43820            43836     ...        \n",
       "25            71109              71115            71118     ...        \n",
       "26            79303              79296            79444     ...        \n",
       "27            38319              38319            38312     ...        \n",
       "28           104430             104427           104501     ...        \n",
       "29            17241              17241            17247     ...        \n",
       "30            31704              31709            31755     ...        \n",
       "...             ...                ...              ...     ...        \n",
       "3162          15911              15911            15934     ...        \n",
       "3163         131887             131885           131897     ...        \n",
       "3164         389891             389938           390079     ...        \n",
       "3165          52410              52410            52417     ...        \n",
       "3166          24496              24496            24492     ...        \n",
       "3167         166994             166994           167004     ...        \n",
       "3168          74749              74749            74780     ...        \n",
       "3170          36299              36299            36440     ...        \n",
       "3171          11668              11668            11674     ...        \n",
       "3172          46133              46133            46223     ...        \n",
       "3173          15885              15885            15835     ...        \n",
       "3174          13833              13833            13817     ...        \n",
       "3175           7083               7083             7108     ...        \n",
       "3176          40123              40123            40224     ...        \n",
       "3177          13249              13247            13411     ...        \n",
       "3178           4812               4812             4804     ...        \n",
       "3179           8569               8569             8568     ...        \n",
       "3180          91738              91881            92199     ...        \n",
       "3181          18106              18106            18075     ...        \n",
       "3182          75450              75450            75466     ...        \n",
       "3183           2484               2484             2491     ...        \n",
       "3184          28205              28205            28262     ...        \n",
       "3185           8667               8667             8680     ...        \n",
       "3186          29116              29116            29148     ...        \n",
       "3187          10247              10247            10231     ...        \n",
       "3188          43806              43806            43599     ...        \n",
       "3189          21294              21294            21290     ...        \n",
       "3190          21118              21118            21103     ...        \n",
       "3191           8533               8533             8541     ...        \n",
       "3192           7208               7208             7169     ...        \n",
       "\n",
       "      RINTERNATIONALMIG2013  RINTERNATIONALMIG2014  RDOMESTICMIG2011  \\\n",
       "1                  0.217533               0.199039          7.239062   \n",
       "2                  1.471487               1.430905         14.554892   \n",
       "3                 -0.036936               0.037130         -4.765309   \n",
       "4                  0.132926               0.133304         -5.611697   \n",
       "5                  0.190529               0.207902          1.773327   \n",
       "6                  1.226762               1.310309        -30.963783   \n",
       "7                  0.294855               0.295676        -14.079431   \n",
       "8                  0.282279               0.266709         -6.147255   \n",
       "9                  0.937564               0.937715         -2.730676   \n",
       "10                 0.191821               0.191747          6.302723   \n",
       "11                 0.365526               0.432965         -1.372511   \n",
       "12                 0.222585               0.224551        -15.517430   \n",
       "13                 0.397346               0.399114         -6.228832   \n",
       "14                 0.148307               0.147831        -10.739034   \n",
       "15                 0.000000               0.000000         -3.674506   \n",
       "16                 3.154451               2.928171          0.377568   \n",
       "17                 0.605660               0.623613         -0.128513   \n",
       "18                 0.000000               0.000000         -4.933212   \n",
       "19                 0.089904               0.091112        -34.370806   \n",
       "20                 0.211475               0.211182          6.672557   \n",
       "21                 1.432049               1.503383          1.727862   \n",
       "22                 0.508862               0.530628         -1.416950   \n",
       "23                 2.675852               2.335672        -10.814040   \n",
       "24                 0.376732               0.381802        -15.667176   \n",
       "25                 1.029445               1.084820          0.280743   \n",
       "26                 0.508685               0.469759          3.236591   \n",
       "27                 0.158017               0.185122         -3.475579   \n",
       "28                 0.604937               0.607249         -1.005694   \n",
       "29                 0.118025               0.118403         -5.010341   \n",
       "30                 1.898674               1.995471         -1.637486   \n",
       "...                     ...                    ...               ...   \n",
       "3162               0.190428               0.191284         -6.872419   \n",
       "3163               0.407045               0.421057         -0.795292   \n",
       "3164               0.917918               0.920084         -0.768369   \n",
       "3165               0.249424               0.249334          3.073868   \n",
       "3166               0.491733               0.494764          4.932534   \n",
       "3167               0.491133               0.495764          0.298898   \n",
       "3168               0.418077               0.433745         -4.056252   \n",
       "3170               3.229379               3.210188          3.735362   \n",
       "3171              -0.168180              -0.083556          4.867842   \n",
       "3172               0.582684               0.580131         -2.844429   \n",
       "3173               0.254210               0.316006         -7.455849   \n",
       "3174               0.282476               0.281561        -12.928060   \n",
       "3175               0.419668               0.416493         -1.546138   \n",
       "3176               0.170364               0.171243          2.771831   \n",
       "3177               0.733999               0.738225         14.510457   \n",
       "3178               2.061643               2.067825          3.328826   \n",
       "3179               0.580450               0.581564          5.001454   \n",
       "3180               1.351748               1.060269         -1.190438   \n",
       "3181               0.000000               0.054211         -9.811802   \n",
       "3182               0.538075               0.528363          7.189792   \n",
       "3183               0.000000               0.000000         -0.402010   \n",
       "3184               1.311272               1.375918          4.618449   \n",
       "3185              -0.228964              -0.228128          4.487917   \n",
       "3186               1.110475               1.102425          0.958527   \n",
       "3187               2.536709               2.680699        -23.970921   \n",
       "3188               0.199291               0.288200          1.072484   \n",
       "3189               1.951042               2.030681         -1.589825   \n",
       "3190              -0.380771              -0.381543        -17.563065   \n",
       "3191              -0.118406               0.000000        -11.642265   \n",
       "3192              -0.281591              -0.278649        -11.772125   \n",
       "\n",
       "      RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  RNETMIG2011  \\\n",
       "1            -2.806268         -2.918570          2.334187     7.530079   \n",
       "2            17.834091         21.989409         19.107379    15.890352   \n",
       "3            -2.389969         -7.017933         -2.227792    -4.618684   \n",
       "4            -4.980826         -6.734902         -0.355477    -5.567855   \n",
       "5            -1.143431         -1.714761         -1.975069     2.034110   \n",
       "6            -4.714313         -1.698594         11.979971   -29.476033   \n",
       "7           -11.683096         -5.307386         -0.049279   -13.791115   \n",
       "8            -4.544217         -5.500169         -4.052258    -5.918638   \n",
       "9             3.877164          3.281474         -2.578717    -1.820451   \n",
       "10            1.228643          5.754623          0.191747     6.494879   \n",
       "11           -2.744174          0.342681          0.136726    -0.960758   \n",
       "12           -0.736296         -8.309838         -1.347305   -15.298874   \n",
       "13          -17.612293         -0.198673         -8.461216    -5.878460   \n",
       "14          -13.263577          4.523377          5.913223   -10.666473   \n",
       "15           -5.086164          6.146651          3.588398    -3.674506   \n",
       "16            7.690643        -13.185995         -3.419475     2.484003   \n",
       "17            1.101868          1.798627          1.760789     0.477336   \n",
       "18           -7.575178         -6.176891        -14.940551    -4.933212   \n",
       "19          -11.276360         -4.585094        -16.126828   -34.370806   \n",
       "20           -4.640249          0.555122          3.986062     6.857173   \n",
       "21            4.088073         -1.432049          3.078355     3.023758   \n",
       "22           -1.019799          4.145361          5.256923    -0.981921   \n",
       "23           -5.179541        -15.316260        -11.919983    -9.698780   \n",
       "24          -11.293921        -16.976490         -9.640509   -15.414480   \n",
       "25           -9.304875         -1.903768          0.366303     1.333530   \n",
       "26            0.723305          1.277916         -1.322743     3.562759   \n",
       "27           -3.776059         -4.398151         -3.411525    -3.214258   \n",
       "28            2.089784         -1.910834         -1.831387    -0.469324   \n",
       "29           -0.704556         -4.425954          0.355208    -4.952081   \n",
       "30           -5.645174         -7.942787         -1.076921     0.314901   \n",
       "...                ...               ...               ...          ...   \n",
       "3162          7.336664         -7.490161          4.016960    -6.746319   \n",
       "3163          0.785682         -2.291512          1.646635    -0.409007   \n",
       "3164          2.146999          0.124593          0.757866     0.064031   \n",
       "3165         -2.261294          6.408289         -0.306872     3.302976   \n",
       "3166         -2.365078         -4.466572         -5.978395     5.340182   \n",
       "3167          2.998287          0.786996         -2.384388     0.741268   \n",
       "3168         -4.967343         -7.080338         -5.774236    -3.708191   \n",
       "3170          2.611880         -3.362825         -3.475492     6.570965   \n",
       "3171          2.720741         17.827111         -8.522727     4.782442   \n",
       "3172         15.621197         -5.701978         -7.811043    -2.413455   \n",
       "3173        -12.890117          3.431840         -2.591247    -7.266294   \n",
       "3174         15.581605         19.067123        -20.976314   -12.782801   \n",
       "3175         -4.207574          1.119116          8.329863    -1.124464   \n",
       "3176          7.832195         -4.672840        -11.546694     2.969819   \n",
       "3177          4.106475         -8.000587         -6.201093    15.102721   \n",
       "3178          6.007872          2.473972         -5.376344     5.201290   \n",
       "3179         -3.945918         -0.928721         -8.956092     5.466705   \n",
       "3180         15.566320          4.694442         -1.787905    -0.779195   \n",
       "3181        -11.578068         14.288867          5.529504    -9.811802   \n",
       "3182         23.120269         24.288458          0.233463     7.690181   \n",
       "3183          1.209921         27.866242        -39.106145    -0.402010   \n",
       "3184          8.101690          7.626081         -9.390640     6.204939   \n",
       "3185          5.506166          2.404121          6.615718     4.257768   \n",
       "3186          8.458886          4.509203          3.574531     2.122452   \n",
       "3187         15.385364        -40.684911        -16.580620   -21.514884   \n",
       "3188         16.195058         -5.292294        -12.991188     1.300672   \n",
       "3189          1.065160         19.283559         14.038186     0.935191   \n",
       "3190         -5.345297         -7.139457        -14.641707   -17.991433   \n",
       "3191         -0.946354         -1.776094        -16.813737   -11.995061   \n",
       "3192         -8.054829         13.093981          2.229188   -12.052414   \n",
       "\n",
       "      RNETMIG2012  RNETMIG2013  RNETMIG2014  \n",
       "1       -2.589008    -2.701037     2.533226  \n",
       "2       19.260182    23.460897    20.538283  \n",
       "3       -2.426738    -7.054869    -2.190662  \n",
       "4       -4.980826    -6.601976    -0.222173  \n",
       "5       -1.022158    -1.524232    -1.767167  \n",
       "6       -3.488591    -0.471832    13.290280  \n",
       "7      -11.391019    -5.012531     0.246396  \n",
       "8       -4.178297    -5.217890    -3.785549  \n",
       "9        4.728966     4.219038    -1.641002  \n",
       "10       1.420618     5.946444     0.383494  \n",
       "11      -2.446889     0.708207     0.569690  \n",
       "12      -0.515407    -8.087253    -1.122754  \n",
       "13     -17.257683     0.198673    -8.062102  \n",
       "14     -13.189890     4.671684     6.061054  \n",
       "15      -5.086164     6.146651     3.588398  \n",
       "16      11.998190   -10.031545    -0.491304  \n",
       "17       1.689530     2.404287     2.384402  \n",
       "18      -7.575178    -6.176891   -14.940551  \n",
       "19     -11.276360    -4.495190   -16.035716  \n",
       "20      -4.455694     0.766597     4.197244  \n",
       "21       5.379043     0.000000     4.581737  \n",
       "22      -0.621829     4.654222     5.787551  \n",
       "23      -0.577718   -12.640407    -9.584311  \n",
       "24     -11.015059   -16.599757    -9.258707  \n",
       "25      -8.461533    -0.874323     1.451123  \n",
       "26       1.421668     1.786600    -0.852984  \n",
       "27      -3.618723    -4.240134    -3.226404  \n",
       "28       2.617023    -1.305897    -1.224138  \n",
       "29      -0.645843    -4.307928     0.473611  \n",
       "30      -3.942161    -6.044113     0.918550  \n",
       "...           ...          ...          ...  \n",
       "3162     7.463159    -7.299733     4.208244  \n",
       "3163     1.140750    -1.884467     2.067692  \n",
       "3164     2.981802     1.042510     1.677950  \n",
       "3165    -2.031332     6.657713    -0.057539  \n",
       "3166    -1.957306    -3.974840    -5.483632  \n",
       "3167     3.426613     1.278129    -1.888624  \n",
       "3168    -4.591436    -6.662261    -5.340490  \n",
       "3170     5.412246    -0.133445    -0.265305  \n",
       "3171     2.550695    17.658930    -8.606283  \n",
       "3172    16.086869    -5.119294    -7.230913  \n",
       "3173   -12.699622     3.686050    -2.275241  \n",
       "3174    15.725879    19.349599   -20.694752  \n",
       "3175    -3.786816     1.538784     8.746356  \n",
       "3176     7.954573    -4.502476   -11.375451  \n",
       "3177     4.693114    -7.266588    -5.462867  \n",
       "3178     7.872385     4.535615    -3.308519  \n",
       "3179    -3.481692    -0.348270    -8.374527  \n",
       "3180    18.041567     6.046190    -0.727636  \n",
       "3181   -11.578068    14.288867     5.583715  \n",
       "3182    23.636059    24.826533     0.761825  \n",
       "3183     1.209921    27.866242   -39.106145  \n",
       "3184     9.323928     8.937352    -8.014722  \n",
       "3185     5.276742     2.175157     6.387590  \n",
       "3186     9.512000     5.619679     4.676956  \n",
       "3187    17.819758   -38.148202   -13.899921  \n",
       "3188    16.307213    -5.093003   -12.702987  \n",
       "3189     2.778678    21.234602    16.068867  \n",
       "3190    -5.774829    -7.520228   -15.023250  \n",
       "3191    -1.064648    -1.894500   -16.813737  \n",
       "3192    -8.337455    12.812390     1.950540  \n",
       "\n",
       "[3142 rows x 84 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop2014_by_county = pop2014[pop2014.SUMLEV == 50]\n",
    "pop2014_by_county\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>Alabama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>Autauga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>Baldwin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1005</td>\n",
       "      <td>Barbour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1007</td>\n",
       "      <td>Bibb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1009</td>\n",
       "      <td>Blount</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1011</td>\n",
       "      <td>Bullock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1013</td>\n",
       "      <td>Butler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1015</td>\n",
       "      <td>Calhoun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1017</td>\n",
       "      <td>Chambers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1019</td>\n",
       "      <td>Cherokee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1021</td>\n",
       "      <td>Chilton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1023</td>\n",
       "      <td>Choctaw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1025</td>\n",
       "      <td>Clarke</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1027</td>\n",
       "      <td>Clay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1029</td>\n",
       "      <td>Cleburne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1031</td>\n",
       "      <td>Coffee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1033</td>\n",
       "      <td>Colbert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1035</td>\n",
       "      <td>Conecuh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1037</td>\n",
       "      <td>Coosa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1039</td>\n",
       "      <td>Covington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1041</td>\n",
       "      <td>Crenshaw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1043</td>\n",
       "      <td>Cullman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1045</td>\n",
       "      <td>Dale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1047</td>\n",
       "      <td>Dallas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1049</td>\n",
       "      <td>De Kalb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1051</td>\n",
       "      <td>Elmore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1053</td>\n",
       "      <td>Escambia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1055</td>\n",
       "      <td>Etowah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1057</td>\n",
       "      <td>Fayette</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3324</th>\n",
       "      <td>72143</td>\n",
       "      <td>Vega Alta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3325</th>\n",
       "      <td>72145</td>\n",
       "      <td>Vega Baja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3326</th>\n",
       "      <td>72147</td>\n",
       "      <td>Vieques</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3327</th>\n",
       "      <td>72149</td>\n",
       "      <td>Villalba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3328</th>\n",
       "      <td>72151</td>\n",
       "      <td>Yabucoa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3329</th>\n",
       "      <td>72153</td>\n",
       "      <td>Yauco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3330</th>\n",
       "      <td>74000</td>\n",
       "      <td>U.S. Minor Outlying Islands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3331</th>\n",
       "      <td>74050</td>\n",
       "      <td>Baker Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3332</th>\n",
       "      <td>74100</td>\n",
       "      <td>Howland Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3333</th>\n",
       "      <td>74150</td>\n",
       "      <td>Jarvis Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3334</th>\n",
       "      <td>74200</td>\n",
       "      <td>Johnston Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3335</th>\n",
       "      <td>74250</td>\n",
       "      <td>Kingman Reef</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3336</th>\n",
       "      <td>74300</td>\n",
       "      <td>Midway Islands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3337</th>\n",
       "      <td>74350</td>\n",
       "      <td>Navassa Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3338</th>\n",
       "      <td>74400</td>\n",
       "      <td>Palmyra Atoll</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3339</th>\n",
       "      <td>74450</td>\n",
       "      <td>Wake Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3340</th>\n",
       "      <td>78000</td>\n",
       "      <td>Virgin Islands of the United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3341</th>\n",
       "      <td>78010</td>\n",
       "      <td>Angaur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3342</th>\n",
       "      <td>78010</td>\n",
       "      <td>St. Croix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3343</th>\n",
       "      <td>78020</td>\n",
       "      <td>St. John</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3344</th>\n",
       "      <td>78030</td>\n",
       "      <td>St. Thomas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3345</th>\n",
       "      <td>78050</td>\n",
       "      <td>Hatoboheit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3346</th>\n",
       "      <td>78100</td>\n",
       "      <td>Kayangel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3347</th>\n",
       "      <td>78150</td>\n",
       "      <td>Koror</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3348</th>\n",
       "      <td>78218</td>\n",
       "      <td>Ngarchelong</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3349</th>\n",
       "      <td>78222</td>\n",
       "      <td>Ngardmau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3350</th>\n",
       "      <td>78224</td>\n",
       "      <td>Ngatpang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3351</th>\n",
       "      <td>78226</td>\n",
       "      <td>Ngchesar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3352</th>\n",
       "      <td>78350</td>\n",
       "      <td>Peleliu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3353</th>\n",
       "      <td>78370</td>\n",
       "      <td>Sonsorol</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3354 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                                 name\n",
       "0      1000                              Alabama\n",
       "1      1001                              Autauga\n",
       "2      1003                              Baldwin\n",
       "3      1005                              Barbour\n",
       "4      1007                                 Bibb\n",
       "5      1009                               Blount\n",
       "6      1011                              Bullock\n",
       "7      1013                               Butler\n",
       "8      1015                              Calhoun\n",
       "9      1017                             Chambers\n",
       "10     1019                             Cherokee\n",
       "11     1021                              Chilton\n",
       "12     1023                              Choctaw\n",
       "13     1025                               Clarke\n",
       "14     1027                                 Clay\n",
       "15     1029                             Cleburne\n",
       "16     1031                               Coffee\n",
       "17     1033                              Colbert\n",
       "18     1035                              Conecuh\n",
       "19     1037                                Coosa\n",
       "20     1039                            Covington\n",
       "21     1041                             Crenshaw\n",
       "22     1043                              Cullman\n",
       "23     1045                                 Dale\n",
       "24     1047                               Dallas\n",
       "25     1049                              De Kalb\n",
       "26     1051                               Elmore\n",
       "27     1053                             Escambia\n",
       "28     1055                               Etowah\n",
       "29     1057                              Fayette\n",
       "...     ...                                  ...\n",
       "3324  72143                            Vega Alta\n",
       "3325  72145                            Vega Baja\n",
       "3326  72147                              Vieques\n",
       "3327  72149                             Villalba\n",
       "3328  72151                              Yabucoa\n",
       "3329  72153                                Yauco\n",
       "3330  74000          U.S. Minor Outlying Islands\n",
       "3331  74050                         Baker Island\n",
       "3332  74100                       Howland Island\n",
       "3333  74150                        Jarvis Island\n",
       "3334  74200                      Johnston Island\n",
       "3335  74250                         Kingman Reef\n",
       "3336  74300                       Midway Islands\n",
       "3337  74350                       Navassa Island\n",
       "3338  74400                        Palmyra Atoll\n",
       "3339  74450                          Wake Island\n",
       "3340  78000  Virgin Islands of the United States\n",
       "3341  78010                               Angaur\n",
       "3342  78010                            St. Croix\n",
       "3343  78020                             St. John\n",
       "3344  78030                           St. Thomas\n",
       "3345  78050                           Hatoboheit\n",
       "3346  78100                             Kayangel\n",
       "3347  78150                                Koror\n",
       "3348  78218                          Ngarchelong\n",
       "3349  78222                             Ngardmau\n",
       "3350  78224                             Ngatpang\n",
       "3351  78226                             Ngchesar\n",
       "3352  78350                              Peleliu\n",
       "3353  78370                             Sonsorol\n",
       "\n",
       "[3354 rows x 2 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "USJSONnames = pd.read_table('us-county-names.tsv')\n",
    "USJSONnames\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>Baldwin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>13009</td>\n",
       "      <td>Baldwin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        id     name\n",
       "2     1003  Baldwin\n",
       "399  13009  Baldwin"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "USJSONnames[USJSONnames['name'] == 'Baldwin']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RINTERNATIONALMIG2013</th>\n",
       "      <th>RINTERNATIONALMIG2014</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>01</td>\n",
       "      <td>003</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>182265</td>\n",
       "      <td>182265</td>\n",
       "      <td>183216</td>\n",
       "      <td>...</td>\n",
       "      <td>1.471487</td>\n",
       "      <td>1.430905</td>\n",
       "      <td>14.554892</td>\n",
       "      <td>17.834091</td>\n",
       "      <td>21.989409</td>\n",
       "      <td>19.107379</td>\n",
       "      <td>15.890352</td>\n",
       "      <td>19.260182</td>\n",
       "      <td>23.460897</td>\n",
       "      <td>20.538283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>009</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>45720</td>\n",
       "      <td>45835</td>\n",
       "      <td>45685</td>\n",
       "      <td>...</td>\n",
       "      <td>0.971985</td>\n",
       "      <td>0.977751</td>\n",
       "      <td>-17.561642</td>\n",
       "      <td>27.005768</td>\n",
       "      <td>-9.525455</td>\n",
       "      <td>-6.540066</td>\n",
       "      <td>-16.702289</td>\n",
       "      <td>27.901591</td>\n",
       "      <td>-8.553470</td>\n",
       "      <td>-5.562315</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     SUMLEV  REGION  DIVISION STATE COUNTY   STNAME         CTYNAME  \\\n",
       "2        50       3         6    01    003  Alabama  Baldwin County   \n",
       "402      50       3         5    13    009  Georgia  Baldwin County   \n",
       "\n",
       "     CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010     ...       \\\n",
       "2           182265             182265           183216     ...        \n",
       "402          45720              45835            45685     ...        \n",
       "\n",
       "     RINTERNATIONALMIG2013  RINTERNATIONALMIG2014  RDOMESTICMIG2011  \\\n",
       "2                 1.471487               1.430905         14.554892   \n",
       "402               0.971985               0.977751        -17.561642   \n",
       "\n",
       "     RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  RNETMIG2011  \\\n",
       "2           17.834091         21.989409         19.107379    15.890352   \n",
       "402         27.005768         -9.525455         -6.540066   -16.702289   \n",
       "\n",
       "     RNETMIG2012  RNETMIG2013  RNETMIG2014  \n",
       "2      19.260182    23.460897    20.538283  \n",
       "402    27.901591    -8.553470    -5.562315  \n",
       "\n",
       "[2 rows x 84 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop2014_by_county[pop2014_by_county['CTYNAME'] == 'Baldwin County']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "counties = pop2014_by_county[['STATE','COUNTY','POPESTIMATE2014']]\n",
    "counties.is_copy = False\n",
    "counties['id'] = counties['STATE'].str.lstrip('0') + \"\" + counties['COUNTY']\n",
    "del counties['STATE']\n",
    "del counties['COUNTY']\n",
    "counties.columns = ['pop','id']\n",
    "counties = counties[['id','pop']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "counties.to_csv('population.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "\n",
       ".counties {\n",
       "  fill: none;\n",
       "}\n",
       "\n",
       ".states {\n",
       "  fill: none;\n",
       "  stroke: #fff;\n",
       "  stroke-linejoin: round;\n",
       "}\n",
       "\n",
       ".q0-9 { fill:rgb(247,251,255); }\n",
       ".q1-9 { fill:rgb(222,235,247); }\n",
       ".q2-9 { fill:rgb(198,219,239); }\n",
       ".q3-9 { fill:rgb(158,202,225); }\n",
       ".q4-9 { fill:rgb(107,174,214); }\n",
       ".q5-9 { fill:rgb(66,146,198); }\n",
       ".q6-9 { fill:rgb(33,113,181); }\n",
       ".q7-9 { fill:rgb(8,81,156); }\n",
       ".q8-9 { fill:rgb(8,48,107); }\n",
       "\n",
       "</style>\n",
       "<div id=\"choropleth2\" />\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.core.display import display, Javascript, HTML\n",
    "\n",
    "display(HTML(\"\"\"\n",
    "<style>\n",
    "\n",
    ".counties {\n",
    "  fill: none;\n",
    "}\n",
    "\n",
    ".states {\n",
    "  fill: none;\n",
    "  stroke: #fff;\n",
    "  stroke-linejoin: round;\n",
    "}\n",
    "\n",
    ".q0-9 { fill:rgb(247,251,255); }\n",
    ".q1-9 { fill:rgb(222,235,247); }\n",
    ".q2-9 { fill:rgb(198,219,239); }\n",
    ".q3-9 { fill:rgb(158,202,225); }\n",
    ".q4-9 { fill:rgb(107,174,214); }\n",
    ".q5-9 { fill:rgb(66,146,198); }\n",
    ".q6-9 { fill:rgb(33,113,181); }\n",
    ".q7-9 { fill:rgb(8,81,156); }\n",
    ".q8-9 { fill:rgb(8,48,107); }\n",
    "\n",
    "</style>\n",
    "<div id=\"choropleth2\" />\n",
    "\"\"\"))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import jinja2\n",
    "\n",
    "choropleth2 = jinja2.Template(\"\"\"\n",
    "\n",
    "require([\"d3\",\"queue\",\"topojson\"], function(d3,queue,topojson){\n",
    "\n",
    "   var data = []\n",
    "   \n",
    "d3.select(\"#choropleth2 svg\").remove()\n",
    "\n",
    "\n",
    "var width = 960,\n",
    "    height = 600;\n",
    "\n",
    "var rateById = d3.map();\n",
    "\n",
    "var quantize = d3.scale.quantize()\n",
    "    .domain([0, 1000000])\n",
    "    .range(d3.range(9).map(function(i) { return \"q\" + i + \"-9\"; }));\n",
    "\n",
    "var projection = d3.geo.albersUsa()\n",
    "    .scale(1280)\n",
    "    .translate([width / 2, height / 2]);\n",
    "var path = d3.geo.path()\n",
    "    .projection(projection);\n",
    "var svg = d3.select(\"#choropleth2\").append(\"svg\")\n",
    "    .attr(\"width\", width)\n",
    "    .attr(\"height\", height);\n",
    "\n",
    "queue()\n",
    "    .defer(d3.json, \"us.json\")\n",
    "    .defer(d3.csv,\"population.csv\", function(d) { rateById.set(d.id, +d.pop); })\n",
    "    .await(ready);\n",
    "\n",
    "function ready(error, us) {\n",
    "  if (error) throw error;\n",
    "\n",
    "  svg.append(\"g\")\n",
    "      .attr(\"class\", \"counties\")\n",
    "    .selectAll(\"path\")\n",
    "      .data(topojson.feature(us, us.objects.counties).features)\n",
    "    .enter().append(\"path\")\n",
    "      .attr(\"class\", function(d) { return quantize(rateById.get(d.id)); })\n",
    "      .attr(\"d\", path);\n",
    "\n",
    "  svg.append(\"path\")\n",
    "      .datum(topojson.mesh(us, us.objects.states, function(a, b) { return a !== b; }))\n",
    "      .attr(\"class\", \"states\")\n",
    "      .attr(\"d\", path);\n",
    "}\n",
    "\n",
    "});\n",
    "\n",
    "\"\"\");\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "\n",
       "\n",
       "require([\"d3\",\"queue\",\"topojson\"], function(d3,queue,topojson){\n",
       "\n",
       "   var data = []\n",
       "   \n",
       "d3.select(\"#choropleth2 svg\").remove()\n",
       "\n",
       "\n",
       "var width = 960,\n",
       "    height = 600;\n",
       "\n",
       "var rateById = d3.map();\n",
       "\n",
       "var quantize = d3.scale.quantize()\n",
       "    .domain([0, 1000000])\n",
       "    .range(d3.range(9).map(function(i) { return \"q\" + i + \"-9\"; }));\n",
       "\n",
       "var projection = d3.geo.albersUsa()\n",
       "    .scale(1280)\n",
       "    .translate([width / 2, height / 2]);\n",
       "var path = d3.geo.path()\n",
       "    .projection(projection);\n",
       "var svg = d3.select(\"#choropleth2\").append(\"svg\")\n",
       "    .attr(\"width\", width)\n",
       "    .attr(\"height\", height);\n",
       "\n",
       "queue()\n",
       "    .defer(d3.json, \"us.json\")\n",
       "    .defer(d3.csv,\"population.csv\", function(d) { rateById.set(d.id, +d.pop); })\n",
       "    .await(ready);\n",
       "\n",
       "function ready(error, us) {\n",
       "  if (error) throw error;\n",
       "\n",
       "  svg.append(\"g\")\n",
       "      .attr(\"class\", \"counties\")\n",
       "    .selectAll(\"path\")\n",
       "      .data(topojson.feature(us, us.objects.counties).features)\n",
       "    .enter().append(\"path\")\n",
       "      .attr(\"class\", function(d) { return quantize(rateById.get(d.id)); })\n",
       "      .attr(\"d\", path);\n",
       "\n",
       "  svg.append(\"path\")\n",
       "      .datum(topojson.mesh(us, us.objects.states, function(a, b) { return a !== b; }))\n",
       "      .attr(\"class\", \"states\")\n",
       "      .attr(\"d\", path);\n",
       "}\n",
       "\n",
       "});\n"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(Javascript(choropleth2.render()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
